Re: Converting Excel Spreadsheet to MySQL table ...

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: rblack@datavisibility.co.uk Maxim Maletsky <maxim@php.net To: "Adam Ferguson" <adam@adamferguson.com> > cc: <php-general@lists.php.net> > 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 maxim@php.net "Adam Ferguson" <adam@adamferguson.com> 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 ________________________________________________________________________