Ms Access export to sql dump file

[djbob2k1]

Hi
I am starting up a website for dvds. i have a huge database in access full of around 10,000 i need to export these to an sql dump file so i can put them into my sql database on me hosting server. i have tryed some programs but they all directly connect to the database. my host does not give me these acces capabilities. but i can run a dump file to enter all the data. Any help most appreciated.

Rob

[tasistro]

I would recomend you get a linux box with mysql. ODBC access from your winbox to your local linux box. Open your dvd access file and your access file which has tables ODBC linked to myslq. Use copy paste to transfer data, access is really good at that. Once you have all the data transfered close files and turn your atention to the linux box. Use mysqldump to create a dbase dump. FTP the file to your server and import from local file.

I had the same problems you did, specially with text fields. The use of Accesse's native copy paste is great.

Saludos
Gerardo