[Chicago] Fwd: Access DB?

Carl Karsten cfkarsten at gmail.com
Wed Oct 21 19:08:43 CEST 2009

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:


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.  I have a fav, digging that up
now, but hitting send first in case I get distracted.

Carl K

More information about the Chicago mailing list