How to import Excel file to mySQL ?
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
i have one excel need to upload to mySQL thru asp.net web application. How to import excel file to mySQL ? or how to import excel to datatable or xml? because alternatively i have code to convert xml to mysql. Thanks.
Regards, Chee ken
I am not sure if following is helpful or not but I first converted Excel file int .CSV using MS-Excel and then used following query. LOAD DATA LOCAL INFILE '' INTO TABLE FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; My query LOAD DATA LOCAL INFILE 'C:\\ukpostcodes\\uk.pc.ll.csv' INTO TABLE postcodes FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
Naveed Kamboh Complexity kills, Write easy code for your self. isolutionteam