Dear DK,
Thanks for the links. I have been too busy to try them.
From my own research, I found that to do this the easiest way is when you can use ODBC. If you can use ODBC in the server then do the following:
1-Create an empty database in MySQL
2-Catalog MySQL database in ODBC
3-Export from Access, for every Access table, select the table, right-click and select Export then pick ODBC database (Save As Type...) , select ODBC entry you create at step 2 and voila!
Very easy. The problem is, most web servers usually, do not let you create ODBC connections, unless you are using a real expensive host. If you have to do without ODBC then I guess the easiest way is to export the access file as comma seperated text file and then import that by using a little php script. This I found from one of your links.
I have yet to try the programs. I will let you know when I do.
_________________
Dust fills my eyes / Clouds roll by / and I roll with them / Centuries cry / Orders fly / and I fall again
Afford best design, implement best solution. Outsource your web design.
Last edited by quantum on Sun May 09, 04 10:55 am; edited 1 time in total
