Macro to copy linked table and paste as local table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thank you very much. that is most helpful.



Allen Browne said:
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.
Click to expand...
 
Back
Top