help with data transferring from excel to mysql

Anon

Hi.
i got an excel file with a table which contains 3 columns, ARTIST TITLE & GENRE.. for example:
METALLICA LOAD ROCK
METALLICA RELOAD ROCK
MEGADETH YOUTHANASIA HEAVY

the thing is that i wanna pass the 11450 files to a table in mysql database. i've latest phpmyadmin and it has an option 4 making that... the thing is that i copy the text contained in all files and i paste in a text file but when i exec command in phpmyadmin all the row enters in one field... i've learn that it has an option which allows phpmyadmin to recognize which data to insert in which field.. it's a char separator. So, if i specify a ";" as a separator my table must be like...

METALLICA; LOAD; ROCK;
METALLICA; RELOAD; ROCK;
MEGADETH; YOUTHANASIA; HEAVY;

I know that if i do this the data will be inserted right, but how can i do to put a ";" at the end of each data (of each column) in each row ? There're 11000 rows more or less... i dunno anything about excel.. but....

IS THERE A BETTER WAY TO TRANSFER THIS DATA FROM EXCEL TO A TABLE IN MYSQL ?

Thanks in advance
Yo gotta help me plz... i'm becoming MAD !!

Henry - Argentina

Anon

Excel will let you save as a tab or comma delimited file. From there you can write a simple PHP script to parse and insert it into the database.

Read the csv or tab delimited text file one line at a time and use explode to seperate out the values.

Anon

Have i to re-save the file in excel ? Have i to change it's extension to another format ?
Plz be more specific cause my english is killing me...
I goota put the mother fu... ";" at the end of each data (in each column) of my damned .xls file... and then that would be all... i take it with phpmyadmin and all done...

thanks and sorry for disturbing...

henry - argentina

Anon

File --> Save As --> "Doc Type" filename.csv

mysqlimport --fields-terminated-by=, -l-lock-tables dbname filename.csv

mysqlimport --help

HTH

Anon

File --> Save As --> "Doc Type" filename.csv

mysqlimport --fields-terminated-by=, -l-lock-tables dbname filename.csv

assuming you have the table created

mysqlimport --help

HTH

Anon

sorry for the double post...