Error for "The text file specification 'IDP Link Specification'

[gmazza76]

Good afternoon,

I have looked on various websites and am unable to find an answer for an error showing as "the text file specification 'IDP Link Specification' does not exist. You cannot import, export, or link using the specification"

I link a table in Access to Excel to update on going figures. I have amended the following in Queries & Connections
- Connection File
- Command Type - SQL
- Command Text - SQL to create the report in Access

Is there anywhere else I need to amend anything as we have switched to a new server and the locations of the files have been amended.

thanks in advance
Gavin