import single record set from one Access BD to second DB

  • Thread starter Thread starter dab1477
  • Start date Start date
D

dab1477

I would like to import specific fields from a SINGLE recordset in an
Engineering database to a separate Marketing Database as an appended
recordset to my main table. The idea here is that Engineering has quoted a
product. Once that product is quoted and accepted, then Marketing needs to
use SOME of the information in order to create and track the new part. If I
can import a single recordset's fields, then I would not have to manually
input all the Engr. data into the Marketing recordset.
I wanted to do this via a macro where I insert a Primary Key of the Engr.
Recordset into the macro. The macro pulls out the Engr. recordset and appends
to my Marketing table. I am unable to get started. Any help is appreciated.
I realize it would be best to have a single DB, but this is what I
inherited. Thanks for the assist to this intermediate neophite user!
 
I apologize, but I don't know how to link databases. Can you point me in the
right direction? Thank you.
 
Back
Top