Share via

Unexpected error from external database driver (1). - DROP TABLE [Sheet1$]

Anonymous
2020-05-23T19:35:36+00:00

Access Database Engine used -

I am using latest Oledb driver from following link. https://www.microsoft.com/en-us/download/details.aspx?id=54920

I used following provider - "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties="Excel 12.0 Xml; HDR = YES;"";

                                         - "Provider=Microsoft.ACE.OLEDB.16.0;Data Source={0};Extended Properties="Excel 12.0 Xml; HDR = YES;"";

Case 1 - 

I am Merging Excel .xlsm file and Excel sheet created using SpreadSheetGear2017.dll in my local code , And then deleting some  of the unwanted excel sheet.

Issue - I am Getting exception Unexpected error from external database driver (1).

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2020-05-23T20:28:10+00:00

    I don't know. Ask them.

    I just know that their product description says it can be used to delete worksheets.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-05-23T20:20:00+00:00

    I would use SpreadSheetGear to delete the sheet.

    Thanks Tom,

    One more point to note here is, i am not getting any driver exception if I am deleting the sheet without Merging.

    Does the SpreadsheetGear need any other driver ?

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2020-05-23T20:10:44+00:00

    I would use SpreadSheetGear to delete the sheet.

    Was this answer helpful?

    0 comments