export from access to mySQL?

[Adrian Leontovich]

My employer has several DBs including Access and mySQL (on different servers
obviously)... he wants certain queries and tables duplicated on the mySQL
DB... short of manually recreating all of the data and procs, can anyone
tell me if there is a way to export data and structure from Access, and
import them to a mySQL DB? Are there utilities?

 

[Larry Linson]

I cannot tell you what kind of permissions you need to create tables in
MySQL, but if you have the proper permisions, you may be able to do what you
want in one of two ways:

-- Link to the MySQL Database and execute an Access
MakeTable query

-- Manually create the table, record, and field structure in
MySQL, link to this table, and execute an Access
Append Query

Larry Linson
Microsoft Access MVP

 

[test guy]

Thanks Larry.. I'll check it out