I'm using the radasyncupload control to import an excel sheet in my application.
However whenever I try to query this excel file I get an OleDBException with the following message:
"The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists....."
I did make sure there's actually a "Sheet1" in the excel file before uploading. Also when I navigate through file explorer to the uploads folder and try to open the uploaded excel file I get a corrupted file error.
I've attached a sample project with an upload page and 2 buttons.
1. The upload button queries the excel file uploaded through the radasyncupload control
2. The query button queries an excel file already part of the project. Querying this file does not give me any exceptions.
Any idea why the file uploaded with radasyncupload gives me this exception?
Had to upload the project elsewhere due to attachment-size limits: