[WEB4LIB] MS Access to MySQL

[Raymond Wood]

Hi,
I would run this by the people on one of the MySQL lists - surely
this dilemma has been faced before by others.

FWIW, is it possible to just export as a CSV file, then import that
into MySQL?

Raymond

On Tue, Dec 19, 2000 at 12:13:09PM -0800, Cameron Metcalf wrote:
> 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