converting from MS Excel to MYSQL databa

[Anon]

Hi,
I have a data in ms excel sheet(*.xls) and i want the data to be update the data to mysql database.

Help me in this regard.

[kevinsequeira]

what i usually do, is convert the xcel sheet to a table in MS Access. And then using MyODBC I transfer the data from access to mysql. If you need more details email me
reg
kevin

[Anon]

Output you excell data to a comma delimited text file and then look at the documentation for the LOAD DATA INFILE command

It would look something like this

LOAD DATA
INFILE "/path/filename" INTO TABLE tablename
FIELDS TERMINATED BY ',' IGNORE 1 LINES
(field1, field2, field3, field4 );

This would be much easier than the previous suggestion, although that will probably work also.