Copy Linked Table

[Peter Nunez]

What's the fastest way to copy a large (2 million records)
linked table to a non linked table? Should I use a
copy/paste or a Select query? Is there another way?

I'm hoping that using a non linked table would speed up my
queries. I would like to do this programatically.

Thanks for the help.

Peter

 

[Tim Ferguson]

I'm hoping that using a non linked table would speed up my
queries. I would like to do this programatically.

Unlikely: it's probably better to look to your network performance, limit
the number of fields and records you request, use snapshots rather than
dynasets, and so on. The problems of trying to maintain two tables in
different locations would be horrendous.

Still, if you really want to do it, it's prolly easiest to run a SELECT ...
INTO or INSERT .... IN....

Best wishes


Tim F