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
export MSAccess data into excel via php ???
Moderator: General Moderators
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/
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/
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.