Export data from mySql to MS Access 2000

A

Anonymous

Guest
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.
 
You must log in or register to reply here.
Back
Top