3 Replies Latest reply on May 10, 2012 12:01 PM by Ian Waring

    Error 0x80040e14 from Jet Engine?

    Ian Waring

      I'm trying to load 3 worksheets from one Excel 2010 spreadsheet, with exactly the same column headers, using Custom SQL. No matter what I do, it says it's loading metadata, waits for 1-2 minutes, then I get:

       

      Database error 0x80004005: Unexpected error from external database driver (1).

       

      Unable to connect to the Microsoft Excel file "O:\Software\Vendors\Alliance Vendors 2012\Combined-SAP-AS400-SalesHistory-V2.xlsx". Check that you have access privileges for the requested file and that it is not open in another application.

       

      I've followed the advice in the Knowledgebase of trying to repair the connection to the Jet driver (all three ways described), but to no avail. Any ideas what I can look at next? The error message isn't that helpful to point at any root cause. Other Excel sheets I have with custom SQL unions work fine (albeit with two rather than three sheets as I have here).

       

      If it helps, the Custom SQL looks like:

       

      SELECT [AS400Sales$].[AM] AS [AM],

        [AS400Sales$].[BSR] AS [BSR],

        [AS400Sales$].[BusinessLine] AS [BusinessLine],

        [AS400Sales$].[BusinessLineDescription] AS [BusinessLineDescription],

        [AS400Sales$].[Category] AS [Category],

        [AS400Sales$].[CD] AS [CD],

        [AS400Sales$].[COGS] AS [COGS],

        [AS400Sales$].[Company] AS [Company],

        [AS400Sales$].[Contribution] AS [Contribution],

        [AS400Sales$].[CustomerAccount] AS [CustomerAccount],

        [AS400Sales$].[CustomerAccountName] AS [CustomerAccountName],

        [AS400Sales$].[InvoiceNumber] AS [InvoiceNumber],

        [AS400Sales$].[ManufacturerPartNumberKey] AS [ManufacturerPartNumberKey],

        [AS400Sales$].[Material] AS [Material],

        [AS400Sales$].[MaterialDescription] AS [MaterialDescription],

        [AS400Sales$].[MaterialType] AS [MaterialType],

        [AS400Sales$].[OrderDate] AS [OrderDate],

        [AS400Sales$].[OrderPosition] AS [OrderPosition],

        [AS400Sales$].[OtherCosts] AS [OtherCosts],

        [AS400Sales$].[OtherXChg] AS [OtherXChg],

        [AS400Sales$].[PostBSRMargin] AS [PostBSRMargin],

        [AS400Sales$].[PostingMonth] AS [PostingMonth],

        [AS400Sales$].[ProfitCenter] AS [ProfitCenter],

        [AS400Sales$].[PulseCompanyID] AS [PulseCompanyID],

        [AS400Sales$].[PULSEID] AS [PULSEID],

        [AS400Sales$].[Purchaser] AS [Purchaser],

        [AS400Sales$].[PVC] AS [PVC],

        [AS400Sales$].[QTYSellOut] AS [QTYSellOut],

        [AS400Sales$].[RevDiscMSEA] AS [RevDiscMSEA],

        [AS400Sales$].[Revenue] AS [Revenue],

        [AS400Sales$].[SalesAssistant] AS [SalesAssistant],

        [AS400Sales$].[SalesOrder] AS [SalesOrder],

        [AS400Sales$].[Sector] AS [Sector],

        [AS400Sales$].[ServiceLine] AS [ServiceLine],

        [AS400Sales$].[ServiceLineDescription] AS [ServiceLineDescription],

        [AS400Sales$].[StockAdj] AS [StockAdj],

        [AS400Sales$].[SubManufacturer] AS [SubManufacturer],

        [AS400Sales$].[SubManufacturerDescription] AS [SubManufacturerDescription],

        "AS400Sales" AS [SourceFile]

      FROM [AS400Sales$]

      UNION

      SELECT [SAP2011$].[AM] AS [AM],

        [SAP2011$].[BSR] AS [BSR],

        [SAP2011$].[BusinessLine] AS [BusinessLine],

        [SAP2011$].[BusinessLineDescription] AS [BusinessLineDescription],

        [SAP2011$].[Category] AS [Category],

        [SAP2011$].[CD] AS [CD],

        [SAP2011$].[COGS] AS [COGS],

        [SAP2011$].[Company] AS [Company],

        [SAP2011$].[Contribution] AS [Contribution],

        [SAP2011$].[CustomerAccount] AS [CustomerAccount],

        [SAP2011$].[CustomerAccountName] AS [CustomerAccountName],

        [SAP2011$].[InvoiceNumber] AS [InvoiceNumber],

        [SAP2011$].[ManufacturerPartNumberKey] AS [ManufacturerPartNumberKey],

        [SAP2011$].[Material] AS [Material],

        [SAP2011$].[MaterialDescription] AS [MaterialDescription],

        [SAP2011$].[MaterialType] AS [MaterialType],

        [SAP2011$].[OrderDate] AS [OrderDate],

        [SAP2011$].[OrderPosition] AS [OrderPosition],

        [SAP2011$].[OtherCosts] AS [OtherCosts],

        [SAP2011$].[OtherXChg] AS [OtherXChg],

        [SAP2011$].[PostBSRMargin] AS [PostBSRMargin],

        [SAP2011$].[PostingMonth] AS [PostingMonth],

        [SAP2011$].[ProfitCenter] AS [ProfitCenter],

        [SAP2011$].[PulseCompanyID] AS [PulseCompanyID],

        [SAP2011$].[PULSEID] AS [PULSEID],

        [SAP2011$].[Purchaser] AS [Purchaser],

        [SAP2011$].[PVC] AS [PVC],

        [SAP2011$].[QTYSellOut] AS [QTYSellOut],

        [SAP2011$].[RevDiscMSEA] AS [RevDiscMSEA],

        [SAP2011$].[Revenue] AS [Revenue],

        [SAP2011$].[SalesAssistant] AS [SalesAssistant],

        [SAP2011$].[SalesOrder] AS [SalesOrder],

        [SAP2011$].[Sector] AS [Sector],

        [SAP2011$].[ServiceLine] AS [ServiceLine],

        [SAP2011$].[ServiceLineDescription] AS [ServiceLineDescription],

        [SAP2011$].[StockAdj] AS [StockAdj],

        [SAP2011$].[SubManufacturer] AS [SubManufacturer],

        [SAP2011$].[SubManufacturerDescription] AS [SubManufacturerDescription],

        "SAP2011" AS [SourceFile]

      FROM [SAP2011$]

      UNION

      SELECT [SAP2012$].[AM] AS [AM],

        [SAP2012$].[BSR] AS [BSR],

        [SAP2012$].[BusinessLine] AS [BusinessLine],

        [SAP2012$].[BusinessLineDescription] AS [BusinessLineDescription],

        [SAP2012$].[Category] AS [Category],

        [SAP2012$].[CD] AS [CD],

        [SAP2012$].[COGS] AS [COGS],

        [SAP2012$].[Company] AS [Company],

        [SAP2012$].[Contribution] AS [Contribution],

        [SAP2012$].[CustomerAccount] AS [CustomerAccount],

        [SAP2012$].[CustomerAccountName] AS [CustomerAccountName],

        [SAP2012$].[InvoiceNumber] AS [InvoiceNumber],

        [SAP2012$].[ManufacturerPartNumberKey] AS [ManufacturerPartNumberKey],

        [SAP2012$].[Material] AS [Material],

        [SAP2012$].[MaterialDescription] AS [MaterialDescription],

        [SAP2012$].[MaterialType] AS [MaterialType],

        [SAP2012$].[OrderDate] AS [OrderDate],

        [SAP2012$].[OrderPosition] AS [OrderPosition],

        [SAP2012$].[OtherCosts] AS [OtherCosts],

        [SAP2012$].[OtherXChg] AS [OtherXChg],

        [SAP2012$].[PostBSRMargin] AS [PostBSRMargin],

        [SAP2012$].[PostingMonth] AS [PostingMonth],

        [SAP2012$].[ProfitCenter] AS [ProfitCenter],

        [SAP2012$].[PulseCompanyID] AS [PulseCompanyID],

        [SAP2012$].[PULSEID] AS [PULSEID],

        [SAP2012$].[Purchaser] AS [Purchaser],

        [SAP2012$].[PVC] AS [PVC],

        [SAP2012$].[QTY SellOut] AS [QTY SellOut],

        [SAP2012$].[RevDiscMSEA] AS [RevDiscMSEA],

        [SAP2012$].[Revenue] AS [Revenue],

        [SAP2012$].[SalesAssistant] AS [SalesAssistant],

        [SAP2012$].[SalesOrder] AS [SalesOrder],

        [SAP2012$].[Sector] AS [Sector],

        [SAP2012$].[ServiceLine] AS [ServiceLine],

        [SAP2012$].[ServiceLineDescription] AS [ServiceLineDescription],

        [SAP2012$].[StockAdj] AS [StockAdj],

        [SAP2012$].[SubManufacturer] AS [SubManufacturer],

        [SAP2012$].[SubManufacturerDescription] AS [SubManufacturerDescription],

        "SAP2012" AS [SourceFile]

        FROM [SAP2012$]

       

      Any clues?

       

      Ian W.