Re.: MS Access to MySQL

[Mark Jordan]

Hi Cameron,

The utilities at http://dbtools.vila.bol.com.br/ claim to be able to
"Import Structure and Data from others Databases (MSAccess 97 and ODBC
Datasources)." Also
http://download.sourceforge.net/pub/mirrors/mysql/Downloads/Contrib/access_to_mysql.txt
looks like it might be useful.

Mark

Mark Jordan
Librarian / Analyst, Systems Division
W.A.C. Bennett Library, Simon Fraser University
Burnaby, BC, V5A 1S6, Canada
Email mjordan at sfu.ca / Phone (604) 291 5753 / Fax (604) 291 3023

>
> Date: Tue, 19 Dec 2000 15:16:10 -0500
> From: Cameron Metcalf <cmetcalf at uottawa.ca>
> To: web4lib <web4lib at webjunction.org>,
> Subject: MS Access to MySQL
> Message-ID: <3A3FC20A.412B0F36 at uottawa.ca>
>
> We're trying to convert an MS Access 2000 database into a MySQL
> database,
> does anybody have/use a utility that will make this conversion (for
> free).
> (we're trying to convert the entire database and structure (which is
> relatively small) *not* just the data)
>
> We've tried the 2nd release of the CYNERGI  (http://www.cynergi.net)
> script, but keep getting the MS Access message "Type mismatch".
>
> The access  help files are useless. and the FAQ at
> http://www.cynergi.net/exportsql
> hasn't offered any possible solutions.
>
> Thanks, in advance for whatever help/advice/insight  you may be able to
> provide.
>
> Cameron Metcalf
> Systems
> cmetcalf at uottawa.ca