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:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 8:57 AM To: [EMAIL PROTECTED] 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
