[SOLVED] Importing data from excel 97-03

[[email protected]]

How do attach excel wooksheet(import) in MySql table "emails", Col 1: email_id, Col 2: emails

 

I saved the data in excel (97-03) where in sheet 1 I have the data, column 1 is headed as email_id and Column 2 is headed as email.

 

Need to import that data in table, do I need to write php code or just import from import button. Does it need to be in CSV form?

 

Please help...

[MadTechie]

CSV would be easier,

via MySQL it would be something like this

LOAD DATA INFILE 'datafile.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

[[email protected]]

Thanks

 

I just saved the file as .CSV and imported the file. It did just perfect!