Forum Discussion
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...
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.
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"