I have created a macro to export a query into an excel file, but keep getting the error 'Could not find database'
The following are requested fields and my entries:
Transfer Type: Export
Database Type: MS Access
Database Name: City Names
Object Type: Query
Source: City Names Database
Structure Only: No
The database name, Source, is 'City Names Database.' I receive an error message that this could not be found. I have tried the Source with and without the C: file path listed above.
If I leave Source blank I get the error message 'Invalid Argument.'
Your suggestions are appreciated.