Exporting of linked table

[nhaider]

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 but from this method is copying
the link and not the actual table.


As usual all help is appreciated.


Cheers

Naushad

 

[Allen Browne]

There's some code here that shows how to export a table to another database:
http://allenbrowne.com/unlinked/backup.txt

It actually creates a new database to export to, but hopefully you can pull
out the part you want.