[Chicago] Fwd: Access DB?
Carl Karsten
cfkarsten at gmail.com
Wed Oct 21 19:18:56 CEST 2009
On Wed, Oct 21, 2009 at 12:08 PM, Carl Karsten <cfkarsten at gmail.com> wrote:
> 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?
>
> Read from MS Access:
> http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-access.html
>
> Scripted:
> http://dev.mysql.com/doc/migration-toolkit/en/scripted-migration.html
>
> I have used this tool interactively on linux, it is nice. Not sure
> what the requirements are to run on linux and read from MS Access.
>
> There are 4 or 5 python odbc modules.
http://wiki.python.org/moin/ODBC
> I have a fav,
http://ceodbc.sourceforge.net - I think. it is written by the same
guy that does the oracle module, trying to verify that this is really
the one. but it is where I would start.
--
Carl K
More information about the Chicago
mailing list