Report Data into Another DB Table

[The Boondock Saint]

Ive got a database in which there is a report with listings.. what id like
to be able to do is export only certain data from each listing into another
database table... and map the data into the right places.... since the two
databases dont have the same structure...

Can anyone point me in the right direction of what i should be looking to
do...

Cheers

 

[Arvin Meyer [MVP]]

Create a recordset to add the record to the second table (Here I used
tblWhatever). Using DAO it might look something like this (aircode):

Dim db As DAO.Database
rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("tblWhatever",dbOpenDynaset)

With rst
.AddNew
!PersonID = Me.txtPersonID
!ColorID = Me.txtColorID
.Update
End With

rst.Close
Set rst = Nothing
Set db = Nothing
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access