If this is a one off excercise, ie you only have to do it once and afterwards things will be dealt with ENTIRELY through the MySQL database, you could save the spreadsheet as a CSV file and work with that.
HTH, Richy ========================================== Richard Black Senior Developer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 951 3481 Email: [EMAIL PROTECTED] Maxim Maletsky <[EMAIL PROTECTED] To: "Adam Ferguson" <[EMAIL PROTECTED]> > cc: <[EMAIL PROTECTED]> Subject: Re: [PHP] Converting Excel Spreadsheet to MySQL table ... 10/01/2003 11:40 Please respond to maxim Excel on its own is a compiled document. However, I think there was some way to do that. I remember I had to do it for MS Aceess files (Access -> mySQL) and i used a tool made by a brasilian guy, (someone remind me the name). I have the feeling that this is accomplisheable. Not sure if directly on Linux box... -- Maxim Maletsky [EMAIL PROTECTED] "Adam Ferguson" <[EMAIL PROTECTED]> wrote... : > Hello ... > > I was wondering if anyone had a good resource or code sample for opening ( or accessing ) an excel spreadsheet using php. I need to be able to convert a spreadsheet of products and info to a table of products in a mysql database. Also ... I need to be able to perform this on a Linux machine. Any help would be great. > > Thanks guys! > Adam Ferguson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
