Using Office 2016 64bit with 64bit ODBC DSN and using a access 2016 database to pull MS queries from text file to excel.
If the query file is stored anywhere on local PC >>>>> it works.
If the query is stored on network location and its accessed via UNC path >>>>> it works.
If the query is stored on network location and its accessed via "Mapped network drive" >>>>> not working.
Comes up with the following error:
Any Suggestion/help?
Thank You in advance.