Data Import from ms excel to sql server

[jainarun]

Hi All,

I have to import the data from MSExcel to Ms Sql Server.

First i have created OLEDB Adapter in which i have passed select statement and connection string of MS Excel.

Then i populated DataSet object with OLEDB adapter.

Now i have to import the table in SQLServer Databse which i populated in DataSet from OLEDB Adapter.

Please do the needful.

Thanks and Regards,
Arun Jain

[shweta123]

Hi,

Please refer this Article

[jainarun]

Hi Swetha,

Thanks for quick response.

But the article u are referring (Given in ADO).

But i want to use ado.net objects DataAdapter,Dat aSet and CommandBuilder.