ASP.NET - how to convert excel data to sql data

Asked By raj kumar's on 02-Feb-14 12:08 PM
hi 
   i have excel file which have 2 column  (employee.no and employee.name) which have more than 1000 records.
how can i load this excel data to my Microsoft SQL table...

                                                        thank you
RAJESH VEMUNOORI replied to raj kumar's on 06-Mar-14 10:39 AM
you can use bulk insert from SQL..jus google about it..
alex smith replied to raj kumar's on 17-Jul-14 05:00 AM
refer the following links which may direct you towards right solution

http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx
http://stackoverflow.com/questions/21670983/import-data-from-an-excel-sheet-into-a-sql-server-database