I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results from each of the worksheets to the right of the first (the master) are pulled into the master via VLOOKUP or INDEX-MATCH. From day to day, after running MRP Generation, I open the most recent Excel workbook and refresh the data on each of the worksheets from right to left.

Every so often, and for no appreant reason, I encounter the "Internal error" message cited above. Sometimes, I am able to close Excel, reopen the workbook, and proceed without error. At other times, I am not able to get past the error by this method, but, while the workbook is still open, I am able to access the data by simply opening MSQuery and running the query without changing anything. But I am still not able to return the results to the corresponding Excel worksheet.

Today, I even restarted Windows 10 to see if that would resolve the problem, but it didn't.

This particular error seems not to be documented in the Knowledgebase or Sage City. Any help will be appreciated. Thank you!

Doug