Simon,

Via ODBC, you can create "linked tables" in Access that point to tables in
your MySql database. With some exceptions, the linked tables act as though
the tables were native Access tables. You can move the data via SQL commands
within the Access application by setting up a query for each table:

insert MyLinkedTable ...
select ....
from MyAccessTable

If you have to account for duplicate records, etc. the MyLinkedTable table
could be a staging table in MySQL.

By updating directly from Access, you can eliminate the export and import
files. Its pretty straight forward.

-- Bill

"Simon Dobson" <replytogroup@nospam.domain.invalid> wrote in message
news:55vj2eF26fcu2U1@mid.individual.net...
> Jerry Stuckle wrote:
>>
>> 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.
>
> Okay, shame, I'll look into doing the conversion before it arrives at the
> Linux box.