List:General Discussion« Previous MessageNext Message »
From:Julian de la Guia Date:May 17 1999 9:52am
Subject:Re: Access to mysql
View as plain text  
Hi Daniel,

Daniel Lacal escribió:
> Hello, I have a trouble. I need to export the database structure and data from a
> Access database to a mysql database.
>     Is this possible?

Yes. It is possible!

There are some methods:

1.- Use ODBC export in Access (you must install myODBC for
Windows and run mySQL in other machine).

2.- Use a script in Access that writes a text file in SQL
with the tables structure and contents too.

Last week, I have converted my Access tables in mySQL tables
with this script. It works fine. You can download it from

Good Luck! :)

Access to mysqlDaniel Lacal17 May
  • Re: Access to mysqlJulian de la Guia17 May