Importing excel data into mysql

[Archbob]

Hi,
Can anyone tell me how to import excel data into mysql. I tried uploading it, but it won't work.

I have a column called "email" in excel that I want to grab and put into a mailing list in mysql. Is there an easy way to do this?

[SantaRosaDesign]

You might try a google search for something like "excel to mysql converter". There are many programs out there to make this easy.

[Archbob]

Is there anyway to get parse the data with php?

[longneck]

i know how to make excel files with php, but not the other way around. your best bet for loading excel data in to mysql is to save the file as CSV and use LOAD DATA IN FILE. and before you ask how to do that, serch for LOAD DATA CSV MYSQL on the forum and you will see lots of examples of how to do it.