Forum Discussion

InsureBI's avatar
InsureBI
Advocate II
10 years ago

Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.

I am trying to refresh a table (with less than 50 records and 200 columns).  The source is a text file on my desktop and I am pretty sure nothing has changed except a few additional records in the ne...
Need Help
pascalvanhove's avatar
pascalvanhove
New Member
9 years ago

I was also able to fix this error by updating the data type of the different columns. I am using as source an Excel file with 32 columns, a mix of text, number, date and percentage data. After correcting the data type of each column in the query editor, this OLE DB/ODBC error was solved.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hey,

     

    I tested different documents. Each time one of the cells contained #N/A I got this error. Once I deleted it, the documents exported fine.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Was experiencing the same issue: Set excel file as data source, added columns to file, tried to refresh, recieived "OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D" error.

       

      Identified Issue: Script for promoted headers is not updating to include headers of new columns

       

      Solved by: Opening Edit Queries, deleteing promoted headers from applied steps, refreshing, slecting "use first row as headers"

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Was also experiencing sameissue: Set excel file as data source, added columns to file, tried to refresh, recieived "OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D" error.

       

      Identified Issue: Script for promoted headers is not updating to include headers of new columns

       

      Solved by: Opening Edit Queries, deleteing promoted headers from applied steps, refreshing, slecting "use first row as headers"