Re: Access to mysql

[Julian de la Guia]

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
http://www.cynergi.net/prod/exportsql

Good Luck! :)

Saludotes,
Julian