Macro to copy linked table and paste as local table

[Clive]

Hi,

Can anyone help me please?


i've got a table in my database that is linked to an external source through
an ODBC connection.

how do i create a macro to copy this table and paste as a local one.

i've managed to work out how to create a macro to copy the table but it just
leaves it as a linked table.

 

[Allen Browne]

1. Create a query that uses this table.
You can use the wildcard so it shows all fields.

2. In query design view, switch this to a Make Table query.
(Make Table on Query menu.)

3. Save the query.

4. Use the OpenQuery action in your macro to run the query.

 

[Clive]

Thank you very much. that is most helpful.

1. Create a query that uses this table.
You can use the wildcard so it shows all fields.

2. In query design view, switch this to a Make Table query.
(Make Table on Query menu.)

3. Save the query.

4. Use the OpenQuery action in your macro to run the query.