Exporting tables not the link

[Guest]

Hi guys,

I have a split database, forms in frontend, data in back. From the frontend
I am attempting to export some of the linked tables (linked to backend) to
another database for subsequent import to a master database. How do I export
the tables without them remaining linked to the backen ie I need new stand
alone copies when exported.

I tried the TransferDatabase Method and also straight SQL CREATE TABLE but
both methods are copying the link and not the actual table.

As usual all help is appreciated.

Cheers
Teewan

 

[Marshall Barton]

I have a split database, forms in frontend, data in back. From the frontend
I am attempting to export some of the linked tables (linked to backend) to
another database for subsequent import to a master database. How do I export
the tables without them remaining linked to the backen ie I need new stand
alone copies when exported.

I tried the TransferDatabase Method and also straight SQL CREATE TABLE but
both methods are copying the link and not the actual table.

See if using a make table query will do what you want. The
key point is to specify the destination database path.