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:33 -0700, Chris Martin [EMAIL PROTECTED] wrote:
 [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
 
  Investigator Verizon Global Security Operations Center
 
  Email:  mailto:[EMAIL PROTECTED]
  [EMAIL PROTECTED]
 
  Desk: 972.399.5900
 
  Verizon Proprietary

 MySQL-Front has an ODBC import feature.

 The old 2.5 version was free (looks like it still is)
 http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm

 It's since been taken over by new developers, and newer versions are
 available for a reasonable fee at
 http://www.mysqlfront.de/download.html

 --
 Chris Martin
 Web Developer
 Open Source  Web Standards Advocate
 http://www.chriscodes.com/

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 21:34:33 -0700, Chris Martin [EMAIL PROTECTED] wrote:
[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
Investigator Verizon Global Security Operations Center
Email:  mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
MySQL-Front has an ODBC import feature.
The old 2.5 version was free (looks like it still is)
http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm
It's since been taken over by new developers, and newer versions are
available for a reasonable fee at
http://www.mysqlfront.de/download.html
--
Chris Martin
Web Developer
Open Source  Web Standards Advocate
http://www.chriscodes.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Yes, It does.
--
Chris Martin
Web Developer
Open Source  Web Standards Advocate
http://www.chriscodes.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]