Import Microsoft Excel data to Mysql

Import Excel To MySQL

First fire up your MySQL Workbench editor or your chosen Mysql Client editor

CSV

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (temp1, temp2, temp3); SHOW WARNINGS

OR

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' (temp1, temp2, temp3); SHOW WARNINGS

TAB  SEPARATED

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
terminated by '\t' lines terminated by '\r\n' (temp1, temp2, temp3);  SHOW WARNINGS
Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn