I am trying to import a table from my existing ms access database to ms excel. When I click on Get External Data, From Access, I get a dialog box that tells me about data link properties. I click on "Test Connection" and it get another dialog box showing a failure. See attached files.
I try to set up a valid link (which I had before) to import a table from my database, but I am running into trouble. Can anyone help?