ERROR: '[08001] Cannot find all files in the data path'

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.

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.

6. Go to Data, select Get Data, select Legacy Wizards, then select From Microsoft Query (legacy).
7. Close and reopen Microsoft Excel.
8. Go to the Data tab at the top of Excel then select Get Data.
9. 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.