I have linked Excel with a few Access queries via Data>Get External Data>New Database Query option. Everything worked fine until I moved the .mdb to a different location on the hard drive. Now whenever I try to refresh from within Excel, I get the following message:
"Microsoft ODBC Microsoft Access Driver 'Path... .mdb' is not a valid path."
How can I point to the new path?
Thank you.
"Microsoft ODBC Microsoft Access Driver 'Path... .mdb' is not a valid path."
How can I point to the new path?
Thank you.