CODEWITHSUNDEEP
phpmysqlms-access
Ganesh Rathinavel
Ganesh Rathinavel

Reputation: 1345

How to export mysql database into ms access using php

I am looking for a way to export a mysql table into MS Access file using php. The server is windows based and I want to export all the data in my mysql table into a msaccess file. I know about mysql to csv to mbd conversion(using phpmyadmin and ms access s/w), but is there a easy and better way to convert the tables into access file say on a mouse click using php? Please note that there are lots records in the mysql table Thanks for the help in advance.

Upvotes: 0

Views: 4236

Answers (1)

rdcapasso
rdcapasso

Reputation: 101

There are a couple of ways to do this. I'd probably just connect Access directly to the MySQL DB as described here. I'm assuming, though, that this is not an option for you.

Assuming you can't do that for whatever reason you can always put together a script to connect to both the MySQL and MSAccess databases via PHP+SQL. This link has a guide to connecting to an Access DB via PHP.

Upvotes: 1

Related Questions