I gave up trying to make it work, and just set up a system DSN on the server, and then created the linked server based on that ODBC connection. Works fine now, I can even switch out the worksheets in the file as I need to.
No comments:
Post a Comment