Another option:
I have just done this for the first time so take it with a pinch of salt. I haven't
seen this approach noted elsewhere in the forum. I offer it up for those searching the archives.
To Export Data from Access to MySQL using myODBC.
You can use myODBC to file|export/save as to an ODBC data source from within Access.
Before you begin:
1.Create an empty database in mySQL that you wish to move the tables to and set appropriate permissions.
3.Set up myODBC (available from mySQL web site).
4.Create an new Data source that uses the mySQL driver.
4.Configure it to point to your mySQL db.
Now open your db in Access and do the following:
1.select a table to export
2.File|Export/Save As
3.To an External File or Database
4.Select ODBC as the type of database to export
5.You probably want to keep the same table name so just hit OK at the next dialog
6.Choose your previously created mySQL DB data source
7.Repeat until all tables are exported.
You have should have all the data in mySQL from your Access tables at this point.
As I said, I haven't used this much but at least one thing to look out for is the key
information being lost (you'll need to recreate all that stuff).
Check that your table definitions and row counts are as you expect before you begin use.
Nico
