Copying Data from Access to MySQL

[ramunune]

i want the procedure to export .mdb file to sql file move file to server using ftp and import into mysql database using a batch file

[jimatqsi]

ramunune,
You can export the data directly to the host of the mysql database very simply. Just make an ODBC connection from Access to the mysql db (that is, make table links in Access) and write queries to move the data. Depending on what version of Access you are using, there might even be an export wizard to help with that part.

You may, however, run into a lot of issues with individual fields. Is the mysql db designed to mirror the Access db? The devil is in the details and you haven't shared many details.

Good luck,

Jim

[zmbd]

ramuneue:
The MySQL user manual is quite user friendly.
Please read chapter 6 and in particular 6.4 Using Connector/ODBC with Microsoft Access

Your only other option is to export the data to a csv file and then call for the file from MYSQL.

In anycase as J has pointed out there are data type issues that you should check for... a few of the MySQL types are not supported in MS Access.
Avoid the Boolean field if possible or make sure that they are all set, there can be issues with null values.

[NeoPa]

Eminently deletable request for work.

As there is some useful info in the replies, however, I'll just close it.

Feel free to ask a proper question if you'd like some help.