RE: Excel Spreadsheet as a datasource

I've done kind of what your asking quite a few times. What I do is save the file as a csv. Then you can just import it right into mysql. I do this for 2 different applications that I wrote. If you need more help just ask. Warren -----Original Message----- From: Herhuth, Ron [mailto:Ron.Herhuth@tatumcfo.com] Sent: Tuesday, March 18, 2003 8:57 AM To: php-windows@lists.php.net Subject: 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