Click here to Skip to main content
15,883,938 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi...
Can u tel me,
How to import excel data into mysql by programmatically is posible in asp.net!
Posted

First read data from excel and put it in a dataset then you have to insert data from that dataset to table.
Take a look at following links:
http://forums.asp.net/t/1608097.aspx/1[^]
http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7[^]
http://www.dreamincode.net/code/snippet1413.htm[^]
 
Share this answer
 
Hi...
its may helpful to u.
write blow cmmd in mysql command promt window.

SQL
Load data local infile ‘file path’ into table databasename fields terminated by ‘,’ enclosed by"’ lines terminated by ‘\n’;


this way also excel file insert into database through command.
thank u.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900