copy linked table

[EllenR]

I have odbc linked table that I would like to copy and paste to local db. My
copy and paste or transferdatabase code makes copy on remote db, instead.
Please someone give me code to do this?
Also, how can I get it to stay linked to remote db long enough for me to use
it?

Thanks