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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Clive" <(E-Mail Removed)> wrote in message
news:E4571994-012E-41E2-ABF5-(E-Mail Removed)...
> 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.
>

Thank you very much. that is most helpful.



"Allen Browne" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Clive" <(E-Mail Removed)> wrote in message
> news:E4571994-012E-41E2-ABF5-(E-Mail Removed)...
> > 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.
> >
>
>