export MSAccess data into excel via php ???

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
chevy
Forum Newbie
Posts: 3
Joined: Fri Aug 19, 2005 3:51 pm

export MSAccess data into excel via php ???

Post by chevy »

I'm wondering if anyone knows whether it is at all possible to take information stored in a microsoft Access 2000 database, and using PHP, to place it into an existing excel spreadsheet? Or even to create a new excel spreadsheet? Does PHP even have the ability to do this? I would appreciate any links or help that someone could offer me on this topic.

Chevy
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Why would you take a ms acccess <-> php <-> ms excell route if you haven skip the php part???

You can query an ms access database through http://www.php.net/com or http://adodb.sf.net.
You will also find a couple of excelwriters, fe http://xlslib.sourceforge.net/
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

there have been a lot of discussions about exporting data to Excel here. It boils down to unless you have certain command line utils, you'll have to export the data from Access as Comma Seperated Values (CSV), which Excel can load, just not all pretty and junk.
chevy
Forum Newbie
Posts: 3
Joined: Fri Aug 19, 2005 3:51 pm

Post by chevy »

Is it possible to export it into an existing spreadshseet and have the values where they need to be? I would like to do this, because I amtrying to merge an existing intranet which employees store customer information in and sales info etc.. But it is not compatible with the accounting softaware. Which is able to import Excel.
Post Reply