I've used COM objects to write to Excel spreadsheets and had no-end of problems. But never tried reading from it, well, did minimal reading to find the next blank cell, so I guess it would be much the same. It's pretty simple stuff using the COM object to access it tho.
chris kranz fatcuban.com -----Original Message----- From: Herhuth, Ron [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 13:57 To: [EMAIL PROTECTED] Subject: [PHP-WIN] Excel Spreadsheet as a datasource Has anyone successfully used an Excel spreadsheet as a datasource? I realize that it is a flimsy datasource but I have a need to quickly and dynamically take the information stored in spreadsheets and manipulate the data and write them to a SQL database. I would be grateful for any assistance or information on how to do this. Thanks, Ron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php