Error thrown when querying uploaded Excel

3 posts, 0 answers
  1. Raoul
    Raoul avatar
    33 posts
    Member since:
    Apr 2012

    Posted 03 Sep 2015 Link to this post

     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. Hristo Valyavicharski
    Admin
    Hristo Valyavicharski avatar
    975 posts

    Posted 07 Sep 2015 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Raoul
    Raoul avatar
    33 posts
    Member since:
    Apr 2012

    Posted 07 Sep 2015 in reply to Hristo Valyavicharski Link to this post

    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.

Back to Top