Sending Dataset To SP

Another way is SQL BulkCopy

Thank u it helps a bit

--Regards,
Lakshmi

Hi,

Please see below link.
http://insqlserver.com/content/how-import-ms-excel-data-sql-server-table-using-cnet

Here you will get the code for import MS Excel data to SQL Server table using c#.net.

You can also try this,

Export data from Excel to new SQL Server table

select *
into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')

Hope this will help you.

Thanks.