transferring data between mySQL and msAccess

[diverDave]

I have a server side mySQL database and want to transfer information from it to a client side msAccess database (being used for Simply Accounting). Does anyone have any ideas?

Thanks in advance.
Dave.

 

[Nero]

I have a server side mySQL database and want to transfer information from it to a client side msAccess database (being used for Simply Accounting). Does anyone have any ideas?

Thanks in advance.
Dave.

Dave,
I use MyDB Converter to transfer data from Access To MySQL and vice versa.
It cost me about £20 at the time but I think it has gone up a bit now.
http://www.softguru.net/

 

[diverDave]

Unfortuneatly, mySQL uses a JDBC driver - but I should be able to have the server produce a file that can be downloaded to the user's computer and then access that file with an ODBC driver. And if not I can always purchase the solution.

Wish me luck.

Thanks again.
Dave.