Simon Dobson wrote:
> 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?

That's the point. NO!

You need the MS JET engine to access a .mdb file. And that only runs on
Windows. I don't know of anything which allows you to get the data when
the .mdb file is on a Unix system.

Have them export the data and import it into MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================