This is a migrated thread and some comments may be shown as answers.

Error thrown when querying uploaded Excel

2 Answers 85 Views
AsyncUpload
This is a migrated thread and some comments may be shown as answers.
Raoul
Top achievements
Rank 1
Raoul asked on 03 Sep 2015, 12:49 PM

 Hey guys,

 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:

http://we.tl/gcko7it2HH​

2 Answers, 1 is accepted

Sort by
0
Hristo Valyavicharski
Telerik team
answered on 07 Sep 2015, 08:36 AM
Hi Raoul,

Perhaps this exception is not related to RadAsyncUpload. The easiest way to check that is try querying Excel file without uploading it with AsyncUpload. Make sure that the excel file has this sheet: "Sheet1$"

Regards,
Hristo Valyavicharski
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Raoul
Top achievements
Rank 1
answered on 07 Sep 2015, 11:22 AM

That's exactly what I did. Querying the same excel file that I've tried uploading doesn't give me any problems. 

And yes I have checked that Sheet1 exists....

 

Again: In the sample project I've uploaded I've clearly stated that when querying an UPLOADED file i get the exceptions. However when querying an excel file which is not uploaded via RadAsyncUpload, I haven't had any issues.

Tags
AsyncUpload
Asked by
Raoul
Top achievements
Rank 1
Answers by
Hristo Valyavicharski
Telerik team
Raoul
Top achievements
Rank 1
Share this question
or