[Chicago] Fwd: Access DB?

Carl Karsten cfkarsten at gmail.com
Wed Oct 21 19:30:40 CEST 2009

On Wed, Oct 21, 2009 at 12:18 PM, Carl Karsten <cfkarsten at gmail.com> wrote:
> 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.


Yup, that's the one.  What is odd is Anthony Tuininga is not listed,
but he is the one I worked with.

Copyright © 2007-2009, Anthony Tuininga.
Copyright © 2001-2007, Computronix (Canada) Ltd., Edmonton, Alberta, Canada.

Carl K

More information about the Chicago mailing list