Skip to main content

The Microsoft Access database engine could not find the object 'Sheet1' error solution

If there is really a tab named Sheet1 that is trying to be read in the relevant Excel, Sheet1$ SHOULD be used INSTEAD of Sheet1 as the name.

string sheetName = "sheet1$"; cmd.CommandText = "SELECT * FROM [" + sheetName + "]";