I have a database that contains a bunch of linked tables that I want to
make changes to the data on. However before I apply my queries to the
linked tables I would like to test them first by running them on a
separate copy of the tables.

Is there a way that I can import linked tables (data and structure)?
Everytime I try to do it I just get another linked table. But I want a
completely separate copy.

I wouldn't import them. I'd make a second physical copy of the database
where the linked tables reside and then using the Linked Table Manager, link
the tables to this test database. Run your queries and verify the data,
then link them back to the original database.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"arod" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a database that contains a bunch of linked tables that I want to
> make changes to the data on. However before I apply my queries to the
> linked tables I would like to test them first by running them on a
> separate copy of the tables.
>
> Is there a way that I can import linked tables (data and structure)?
> Everytime I try to do it I just get another linked table. But I want a
> completely separate copy.
>

How are you trying to do it? If you just copy a linked table, you get
another linked table. Try using a Make Table Query instead:

SELECT LinkedTableName.* INTO CopiedTableName
FROM LinkedTableName;

-Michael


"arod" wrote:

> I have a database that contains a bunch of linked tables that I want to
> make changes to the data on. However before I apply my queries to the
> linked tables I would like to test them first by running them on a
> separate copy of the tables.
>
> Is there a way that I can import linked tables (data and structure)?
> Everytime I try to do it I just get another linked table. But I want a
> completely separate copy.
>
>