Last post Dec 23, 2014 10:11 PM by Edwin Guru Singh
Dec 22, 2014 11:08 PM|vishnuRocky|LINK
How to insert 5 lakh data to sql table from xls file using c#
Dec 22, 2014 11:19 PM|brajeshkarna|LINK
I think this link may help.
Dec 22, 2014 11:21 PM|wmec|LINK
Check this example
Dec 23, 2014 10:11 PM|Edwin Guru Singh|LINK
As per your case ,You can insert from xls into Sqlserver by using SqlBulkCopy
For your reference,the following link can be guide to do Bulk Insert from xls into Sqlserver respectively.
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.
Hopefully this will be helpful for you.