Last post Apr 17, 2010 06:47 AM by Lien.Revanth
Apr 15, 2010 02:23 AM|Lien.Revanth|LINK
Is there any way to import XLS data into MySQL database which is have similar table structure..?
Kindly let me know As soon as possible
Apr 15, 2010 05:59 AM|Waqar_ali|LINK
See following links,
Apr 17, 2010 06:47 AM|Lien.Revanth|LINK
thanks buddy :)
It really worked for me :)
following are steps and the Querry....
design the table into which you wanna load the CSV file whose table structure as similar to the CSV file.
run the command
LOAD DATA LOCAL INFILE 'I:\\SYSTEM LOCK\\Local Drive D\\<som folfer>\\wishes' INTO TABLE <DATABASENAME>.<TABLENAME> FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (`sno`, `desc`, `pdate`);
NOTE : Make sure that while exporting it is ';' separeted values