Solution Properties
Solution ID:
260305104428110
Last Modified Date:
Fri Jul 10 15:25:25 UTC 2026
Taxonomy Path:
Case category//I have a problem with...//integration
Author:
[email protected]
ERROR: '[08001] Cannot find all files in the data path'
Description

Microsoft’s April 2024 Excel update hides Microsoft Query under Legacy options. This results in the error when you use Excel with Sage 50 Accounts.

Cause
Resolution

To resolve this, you'll need to turn Microsoft Query back on:

  1. Go to Microsoft Excel.
  2. Go to File then select Options.
  3. Select Data.
  4. In the Show legacy data import wizards section, tick From Microsoft Query (Legacy) then select OK.

Data options menu.

  1. Go to Data, select Get Data, select Legacy Wizards, then select From Microsoft Query (legacy).
  2. Close and reopen Microsoft Excel.
  3. Go to the Data tab at the top of Excel then select Get Data.
  4. Select Legacy Wizards then select From Microsoft Query (legacy).

If the issue persists

  1. Link to your data in Microsoft Excel using ODBC.

    NOTE:

    If the issue persists after following all the steps in this article, we recommend contacting your IT provider to review your environment.
     



Steps to duplicate
Related Solutions