Importing excel data to sql server

[Aswathy]

Hi,

I have a excel sheet "Biodata.xls" (already containing data).
I need to load this data to a table "Details " in sql server.

I have done it using the DTS wizard.
Is it possible to do this through some code in c#?

Can somebody help me out.......

Thanks,
Aswathy

[pygmalion]

it can certainy be done using an ODBC, OleDB or ADO.NET connection. can you please give us a little more specifics about your excel sheet, database and connection(s)?

hope to help you out soon
pygmalion

[blacklocist]

Try this,

http://www.c-sharpcorner.com/UploadFile/mgold/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET11282005034134AM/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET.aspx