reading data from excel file

[madhu sudhan]

HI,

I want to read data from excel file and export this data to dataset. I
know abt the basics of opening a file using application, workbook and
worksheet classes. But i don't know how to read data from the excel
file to populate it into the dataset. I think i have to use the class
Range. Can any one explain how to do it ?????????????

Thank YOU

 

[sloan]

The basics are here:
http://www.dotnethero.com/hero/DataSet/excel.aspx?nmx=3_3


I'd avoid importing the COM library (Microsoft Office 10.0 or similar) if
possible.

You should be able to get it all with an OLEDB driver.