Coverting MS Access Database into MySQL

Okay, first time in doing something like this, I need to get an Access database into mySQL..

Is there an simple solution to this, does MS Access give me the ability to export the database into an "SQL" file??

With all the structure and data intact?

In short, I'm looking for a quick way of gett ing all the data out of Access and into MySQL for use on the web..

Any help would be quite appreciated.

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

i have done this, but instead of spending time to find a "simple" solution for this i just exported the tables to a tab delimited text file and then wrote a simple php script to read in the data and store it in a mysql db

this was pretty quick and easy, but if there is some kind of "accessdump" feature, i would love to hear about it too

Well, I'd go that route, but since I don't know much about Access, and I didn't create this database, I'm not even sure what the current database structure is... So creating a the tables would would make it a bit difficult to simply use the CSV data.. I dunno..



------------------
SnR Graphics,
Low Cost Hosting and Web Development.

The MySQL website has a page of links to third-party software and utilities at
http://www.mysql.com/information/links.html

The one you want is called ExportSQL, at
http://www.cynergi.net/exportsql/

This is an Access module to dump an Access database into mysql-readable script, including table drop, and create, and it even (mostly) handles type conversion. You might have to edit the resulting SQL file for certain column type conversions, but it's generally right on the money.

Thanks for the link and the response.

I've downloaded the text file from the site, but I'm still not really sure "how" to use it.

It obviously contains scripting data, and it says it's a module for Access.. But, alas, I'm not all the familiar with MS Access, at any capacity.

Any pointers?

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

Open your Access Database, in the tabbed window that lets you choose Tables, Queries, Forms, etc... choose Modules. Click the New button on the right, paste in the code from the script, close, and you will be prompted to save the module. Once saved, just double-click on the module icon, and it will run the dump.

Thanks for the feedback, I had figured it out. Not a real complicated process, but one might have thought that MS would have just created the program with the export for SQL files.

But that would have made just too much sense and meant that MS would have had to play nice with others.



------------------
SnR Graphics,
Low Cost Hosting and Web Development.

had major problems with access but found the best way to convert a TABLE was to export as text .txt from MSAccess
open in wordpad remove the top line (the field names) strip the " quote marks.

then create the table in mysql
then run this
mysql> LOAD DATA INFILE "data.txt" INTO TABLE your_table;

Make sure you u to your database.

This is only good for tables hope its some help