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
Member
3 Points
18 Posts
How to import xls data to MySQL - Vry Urgent
Apr 15, 2010 02:23 AM|Lien.Revanth|LINK
Dear Geeks,
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
Kind Regards
Sid
Contributor
2003 Points
685 Posts
Re: How to import xls data to MySQL - Vry Urgent
Apr 15, 2010 05:59 AM|Waqar_ali|LINK
See following links,
http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html
http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1
Software Engineer
Please mark as answer if it help you.
Member
3 Points
18 Posts
Re: How to import xls data to MySQL - Vry Urgent
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
Happy querying
Regards
Sid :)