Fwd: Best way to get Access DB structures into MySQL ??

2004-09-12 Thread GH
-- Forwarded message -- From: GH [EMAIL PROTECTED] Date: Sun, 12 Sep 2004 02:49:02 -0400 Subject: Re: Best way to get Access DB structures into MySQL ?? To: Chris Martin [EMAIL PROTECTED] Does this also allow for the importation of the data as well? On Sat, 11 Sep 2004 21:34

Re: Fwd: Best way to get Access DB structures into MySQL ??

2004-09-12 Thread Chris Martin
GH wrote: -- Forwarded message -- From: GH [EMAIL PROTECTED] Date: Sun, 12 Sep 2004 02:49:02 -0400 Subject: Re: Best way to get Access DB structures into MySQL ?? To: Chris Martin [EMAIL PROTECTED] Does this also allow for the importation of the data as well? On Sat, 11 Sep 2004

Re: Best way to get Access DB structures into MySQL ??

2004-09-11 Thread Peter Brawley
Christopher, 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 ?? The only way I know is to use a tool like

Re: Best way to get Access DB structures into MySQL ??

2004-09-11 Thread Martijn Tonies
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.

Re: Best way to get Access DB structures into MySQL ??

2004-09-11 Thread Chris Martin
[EMAIL PROTECTED] wrote: 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

Best way to get Access DB structures into MySQL ??

2004-09-10 Thread christopher . l . hood
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