import multiple linked tables

[Davros]

Hello everyone
i don't post much these days as I'm doing a lot of GIS work. however i still keep an access database.
i have a lot of linked tables and would like to import the tables locally all in one go. i know i can do it one at a time but this is tedious and time consuming. anyone how would i go about it?

thanks in advance

 

[boblarson]

Hello everyone
i don't post much these days as I'm doing a lot of GIS work. however i still keep an access database.
i have a lot of linked tables and would like to import the tables locally all in one go. i know i can do it one at a time but this is tedious and time consuming. anyone how would i go about it?

thanks in advance

Why would you need to do them one at a time (unless they are all in separate places)? Just delete all of your linked tables by selecting them and hitting your delete key (it will only delete the links). Then use

File > Get External Data > Import

and select the place to get them from and boom they are there.

 

[Davros]

thanks boblarson
sorry i've been so long in replying. perhaps i'm lazy and we also have a lot of network problems at work. i've now done two macros which delete the linked tables then import them onto my local drive. it just saves me mucking about looking in different location for the actual tables

thanks anyway