I need to transfer data from ACCESS to MySQL using PHP... Why? My customers are connecting to internet using dial-up connection and they need a lot of time to add their adverts to site, because of slow connection. It is much faster to add their adverts locally in Access database (they know how to use it) and after that they do upload of that file, PHP parse it and put data from ACCESS database to MySQL database. Is it posible? I know that I can convert from ACCESS to CSV or similar format but I wanted automatization. :-)
You can use Access' VBA programming language to save the data to CSV, search the MSAccess Help file for CSV Export...
Then let them upload the CSV via a PHP page that will parse the CSV into your mySQL tables...
