That would do... but what if i want the function to loop itself so that all linked tables are automatically transferred <lets say I have 50+ linked tables>... also is there another way that i dont need to create a query???
The problem in using a query is that the exported result table did not...
Lets say I have DBase1.mdb file where tables are linked from an sql server and DBase2.mdb where I want the tables from DBase1.mdb be transferred as local table...
I want to accomplish this using vba...and not manually where I copy the tables and paste it to another file getting the data and the...
