Page 1 of 1
export MSAccess data into excel via php ???
Posted: Thu Sep 01, 2005 11:43 am
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
Posted: Thu Sep 01, 2005 11:48 am
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/
Posted: Thu Sep 01, 2005 11:48 am
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.
Posted: Fri Sep 02, 2005 8:16 am
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.