Copy Linked Table

  • Thread starter Thread starter Peter Nunez
  • Start date Start date
P

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
 
I'm hoping that using a non linked table would speed up my
queries. I would like to do this programatically.
Click to expand...

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
 
Back
Top