View Single Post

  #3 (permalink)  
Old 03-16-2007
Simon Dobson
 
Posts: n/a
Default Re: Open source tool for converting Microsoft Access (MDB) to MySQL

Jerry Stuckle wrote:
>>
>> The best solution for us would be getting the MDB file onto the Linux
>> box then having Linux put the data into MySQL tables. The servers
>> aren't on the same LAN so opening the ODBC can of worms is something
>> I'd want to avoid if at all possible.

>
> The question remains - can you run your access database on Linux? AFAIK
> you can't. You can get to it with ODBC from a Linux box, but the
> database itself must run on a Windows box.


Maybe my original post is misleading. I said I wanted to 'pull' the data
from the Microsoft database, which suggests the MDB database being
online and 'live'. I don't want to 'run' the access database, I just
want to get the data out of it.

My question is simply this.

I have an MDB file on a Linux box. Do open-source tools exist to read
the data from this and put it into a MySQL database?
Reply With Quote