write a macro which will create a file with insert statments from the data in the excel sheet. run the macro get the file and run it on the linux box Gurvinder Singh www.gurvindersingh.com
<[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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