Hello,

Is it possible to specify an Excel spreadsheet as a data source through ADO.NET? I read somewhere that it is possible... Would you use the OLEDB objects (OLEDBConnection, OLEDBDataAdapter, etc) to connect to it? What does your connection string have to look like?

Thanks,

Brian Mains

__________________
Brian

You can use your excel file as source and use following method to connec to it:

string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\ExcelToXml\\foodgroup.xls;" +
"Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(strConn);

hope this helps.
Bharat Gadhis

Bharat Gadhia

OK. I Didn't know you used the Microsoft JET provider to get to it. Learn something every day.

Thanks a lot.