Excel to sql database in asp.net

C# Corner

Sharad Chandra

15y1.7k.NET

Hi all
i want to import all data from excel and save to my sql database in flexible way,
how i do it, help me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka15y ago

You could use OPENROWSET, something like:

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
  'Excel 8.0;IMEX=1;HDR=NO;DATABASE=C:\FILE.xls', 'Select * from [Sheet1$]'

For more check here

http://www.c-sharpcorner.com/UploadFile/vivek4u_swamy/Excel2Sqlserver01162009021905AM/Excel2Sqlserver.aspx