Macro to copy linked table to local

[RAMMY987]

Hi,

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.

 

[burrcm]

Use a make table query which you can fire with a macro if necessary.

Chris B

 

[RAMMY987]

Thanks.

this has worked a treat.