[Chicago] Fwd: Access DB?

Samir Faci samir at esamir.com
Wed Oct 21 18:35:01 CEST 2009


Just a few quick hits for migrating.  Not python..but you can use the
mysql database from python once converted.

http://radio.javaranch.com/balajidl/2006/03/20/1142854129729.html
http://www.linuxquestions.org/linux/answers/Applications_GUI_Multimedia/Moving_MS_Access_Data_to_Linux

I haven't found anything odbc for acces ms. access, but freetds does
let you interact with mssql server.  Not sure if that would be useful
to you or not.  Though, I think the top 2 links should let you migrate
your data to psql/mysql and from there you should be good.

--
Samir

On Wed, Oct 21, 2009 at 11:20 AM, Chris McAvoy <chris.mcavoy at gmail.com> wrote:
> Hey All,
>
> I'm converting an Access database to MySQL or Postgres, and am looking
> at tools.  I've seen some examples of connecting the DB through ODBC,
> but it seems like that needs a windows machine.  I found a command
> line tool in linux that can access the db, which is probably my best
> bet, but I wanted to through it out to you smart folks to see if
> there's a better Pythonic way to approach the problem.  I know there's
> a python library that can read Excel natively, anything similar for
> Access?
>
> Chris
> _______________________________________________
> Chicago mailing list
> Chicago at python.org
> http://mail.python.org/mailman/listinfo/chicago
>



-- 
--
Samir Faci
*insert title*
`fortune`


More information about the Chicago mailing list