kioto wrote: > How to read and get data from Excel Files and Access Files. > Can you post me articles and tutorials on the web-sites that explain > the basic concept to create an interface for PHP and this files-type. > Thanks so much to all.
I believe there is a script on http://phpclasses.org to read/write ExCel files... Or, if not, Google for it, and it should turn up. I know they were using it at my previous job, and they didn't write it themselves. I pretty much stayed as far away from that MS code as I could, so never knew where it came from. Don't know how good it is, even. You may find it easier and more reliable to have the users export/import in CSV format instead, as others have noted. As for MS Access, you could set up a DSN and use http://php.net/odbc to connect to the database. Please note that MS Access was *not* designed for multiple connections, and it *will* have difficulties if your script gets any kind of heavy load (many users) on it. You may also want to consider OpenOffice as an alternative to these software products -- you might have better luck finding the internal formats of OpenOffice files published and more support in the OpenSource community for software that reads/writes their file formats. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
