Hi
I get above error on line. - ExcelConnection.Open();
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Customer.XLS;
Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbConnection ExcelConnection = new System.Data.OleDb.OleDbConnection(ConnectionString);
string ExcelQuery;
ExcelQuery = "Select * from [Sheet1$]"; // from Sheet1";
System.Data.OleDb.OleDbCommand ExcelCommand = new System.Data.OleDb.OleDbCommand(ExcelQuery, ExcelConnection);
ExcelConnection.Open();
Thanks