try to use code below to access the .xls file, got a error. "The Microsoft Jet database engine could not find the object 'DriverDistanceData'.
Make sure the object exists and that you spell its name and the path name correctly" I know the error from line 1. I tried a lot ways in line 1, but didn't work
protected void BtloadData_Click(object sender, EventArgs e)
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DriverDistanceData.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
OleDbCommand command = new OleDbCommand("Select * FROM DriverDistanceData", connection);
// Create DbDataReader t
View Complete Post