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...
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.