Jimmy Dimes
New Member
- Joined
- Jul 27, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have queries in a MS access database linked to a MS SQL database ("SSCAPP"). When I try to display the queries in Excel (using get external data from an access database), I can see the queries but when I try to load them I get the following error "[Data format error] ODBC--Connection to 'SSCAPP' failed". I was able to do this in the past, it stopped working after an office 365 update.