Importing data from MS ACCESS


I am wondering if anyone is able to point me in the right direction on how to go about importing an existing data stored within a MS ACCESS database, to be input into a SQL DB i have created.

Is a .csv with some Php loop the best way to go about this, or is there a simple one button approach (I am forever the optimist!)

Thank you in advance.

Ty Cups

I shouldnt have a problem with server permissions, as i am still in dev on the mysql db on a local apache test server.

I’ll look into that command and see if i can work out how to use it. I’m a newbie to php, so more questions likely to follow in due course :wink:


If your “sql db” is mysql then one way would be to create a csv dump of the access tables, then use LOAD DATA INFILE command.

Should be easy enough to create a little test on a single table, the big bugbear could be permissions if you are on a shared server. The csv file must reside on that server IIRC.

If you use PhpMyAdmin there is a handy import button/link which hides all the messy stuff and you just upload a file, IIRC.