Exporting tables not the link

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...


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