I want to import data from one Access db into another. However, when I link to the db, the tables I want to grab are not available.
I've linked to the db in question from Excel, in which I can select one of the available options, and then change the Command text (in Connection Properties) to...