Link to home
Start Free TrialLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

reading a table from another access database

Experts,


Can I read a table in a query from a database that is located on another drive by just giving the path name.

"\\patha\libary\Reportsfoldera\folderb\WEEKLY_extracts\database_a\table_1"
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of morinia

ASKER

Just curious,  can you link to a query?
Just curious,  can you link to a query?

Not that I am aware of. You can however import the query, but that is not the same as linking.
Also it will not update automatically.