Steve Tipple said:

Cannot find all files in data path

This is the specific problem. Whatever datapath you have your DSN connection configured to use in Excel does not contain all of the expected DTA files. The default path that is used for the v28 DSN will be C:\ProgramData\Sage\Accounts\2022\company.000\ACCDATA. However if you previously used v27, upgraded to v28 and converted your data, the data will likely still be in the v27 default folder C:\ProgramData\Sage\Accounts\2021\company.000\ACCDATA. Assuming this is the case you have 3 options.

1. Move the data from the v27 to the v28 path (e.g. a backup/restore from within the application) or just move it on disk and reconnect in the main application).

2. Edit the DSN in ODBC Data Source Administrator (a tool that is part of Windows rather than a Sage specific thing) and change the default path for the v28 driver to be the old, existing location of your data.

3. Create a new DSN in ODBC Data Source Administrator, set it's data path to be the old, existing location of your data, and change your connection in Excel to use this DSN instead of the default v28 one.

Thanks Darren- this was useful. For anyone else struggling: The file path in Sage appears to have changed from Company.000 to Company.001 between versions. I was able simply to edit this via Control Panel - Administrative Tools - ODBC Data Sources, and then change the Sage v28 data source file path to match the file path given by Sage (go to Sage, Help, About to see yours). Just to note that my Excel is pulling it from the 32 bit version (but I changed both anyway).

That sounds a bit strange. I've checked in the code and there have been no changes to the default path so it remains Company.000. Certainly if it is set to Company.001 for some reason changing it to Company.000 should definitely sort the issue.

Glad to hear it is sorted for you.