How to export mysql database into ms access using php

Question

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.

Can't you just go into your phpMyAdmin and Export the table as a CSV, then import it into Access? Unless you write a script that does everything you want at the click of a button, I don't think you're going to find a magical button that does it for you. — Unexpected Pair of Colons
– Unexpected Pair of Colons, Commented Apr 25, 2013 at 14:08
I am doing it for a company. They cant always export the table as csv then import it into ms access. There might be some way to program it in php. Yes I am expecting a "Magical Button" solution here. — Ganesh Rathinavel
– Ganesh Rathinavel, Commented Apr 25, 2013 at 14:11

rdcapasso · Accepted Answer · 2013-04-25 14:36:46Z

1

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.

answered Apr 25, 2013 at 14:36

rdcapasso

1013 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to export mysql database into ms access using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related