export linked odbc table

[Pat]

Need to export a linked odbc table to another access
database. When done it is still a linked odbc table.
I need the table with data and definitions and no link.

 

[Tom]

When you export tables the table state is exported as
well. So if the table is a linked table it will be
exported as a linked table. If you need a non linked table
with the data of the linked table try a make table qry
then Xfer.