Download yourself the trial version of Database Workbench
at www.upscene.com and try the Schema Migration tool.
Connect to Access via ADO and migrate the existing structure
to MySQL.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?
Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
Chris Hood
Investigator Verizon Global Security Operations Center
Email: <mailto:christopher.l.hood@stripped>
christopher.l.hood@stripped
Desk: 972.399.5900
Verizon Proprietary