Exporting tables not the link

T

Teewan

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
 
M

Marshall Barton

Teewan said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top