hot to copy large amount of data from one mdb 2 another

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

the data is in different tables

now i use copy/paste w/ excel

but there must be a better and faster
and less RAM hungry method

all suggestions r welcome
 
John Smith said:
the data is in different tables

now i use copy/paste w/ excel

but there must be a better and faster
and less RAM hungry method

all suggestions r welcome
Click to expand...

You don't give much info, but why not create a linked table (in one
database) to a table that actually resides in the other? Then you can
run an append query that copies the records you want from a local table
to the linked table. To link to the table, use File -> Get External
Data -> Link Tables... .

You can in fact do this even without creating a linked table, because
you can use an IN clause in the append query to specify that the target
table is in an external database. However, linking to the table is a
bit simpler.
 
tnx mr Goldgar
i`ll give link a try

Dirk Goldgar said:
You don't give much info, but why not create a linked table (in one
database) to a table that actually resides in the other? Then you can
run an append query that copies the records you want from a local table
to the linked table. To link to the table, use File -> Get External
Data -> Link Tables... .

You can in fact do this even without creating a linked table, because
you can use an IN clause in the append query to specify that the target
table is in an external database. However, linking to the table is a
bit simpler.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top