Re: Synchronization ?

[Jay Alverson]

More info.

If it's just copying the data, then you can use Access to Export to MySQL
via ODBC, via the Access menus (it just uses the Transfer Data Base method).

You can try it with a small test table to see if it does what you need.

I've copied entire Access 2003 tables to MySQL with a few mouse clicks.

I think the steps are:

Setup a System or File DSN for the MySQL
Click on table in Access to highlight
Right Click, choose Export
In the SAVE AS TYPE dialog: Choose ODBC databases (mine's at very bottom)
Then choose the name you want it to appear as in MYSQL
Then choose your data source

After it's finished, login to mysql and compare Count(*) etc, to make
sure.

The structure of the table might be different (column types, etc)

You can also use VBA or a language that can handle COM to do it automatically
using the DoCMD object and .TransferDatabases method. That I've done too.


>

Thanks, Jay