Export data from mySql to MS Access 2000



Well I must say, this place has certainly changed since last I visited.

Anyhow, I am trying to find a way to code for exporting from a mysql database into an access database. I googled and kept finding some shareware but I want to be able to write a prog either in php or vb.net to access the mysql database and export into a ms access db. If anyone knows where I can see a sample or even knows if this is possible in php, please let me know. Appreciate any assistance.

For RPG/AS400 questions and answers, please try www.as400support.com
If you just want to do this once (or only on occasion), it ought to be enought to just use PHP to generate a comma-delimeted file and then import that into Access. If you want to do it daily, you should look into the ODBC functions.