Getting an error while uploading from excel file sheet

Question

HI all I am getting an error given below when uploading the data from excel file. could anyone plz help me soon. The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

Sam Hobbs · Answer

It might be that it cannot find the file. It might be using the name 'Sheet1$ to refer to the object which includes the file.

Suthish Nair · Answer

http://www.connectionstrings.com/excel

Sandeep Shekhawat · Answer

Muralidharan Dheenadhayalan sir said right. But mostly this error comes from retiving data from Excel sheet. in your excel file your first sheet should be Sheet1 r you sure?

Ruchi R · Answer

The name of excel sheet is Sheet1 in my excel file. but still it is give error.

Muralidharan Deenathayalan · Answer

Do you have Sheet1 present in the excel file ? If you have renamed the excel sheet name then use the new name in your code.