Please attempt to have Excel connect to the data using

From Other Sources
From Data Connection Wizard
ODBC DSN
Select the DSN mentioned above for AP92AVMS

Does the rows come back to Excel?


Oops.. see that you say earlier in thread this does work !

I will see if I can get a SQL2017 up and running to test. May take a bit of time.

For now a 2 step process might be all that will work.

1) Data to Access Database using Adagio ODBC
2) Then SQL 2017 Linked Server using the Access Database