Transfering data from one database to another

[Zibinette]

Hi, wonder if anyone can help me...
Trying to transfer part of the information contained in a table into another table, but the fields don't have exactly the same names in one and the other. Example : I have a table with contact info and history of purchases. And I want to transfer the contact info in a contact table and the history of purchases info in a history table.
Thanks !!
Z.

 

[parry]

Hi, you could make a new table (make table query) or alternatively use an append query (to add as new records) or update query (to update existing records) but you will need some link between the tables so Access knows which records to update. You can use the Relationship button to link tables.

 

[dtaylor]

Hi There,
You could also use a Select Into sql statement.

Here is sample that I just used on a project.

Const dbloc = "V:\DataBases\"

Sub TransferData()

Dim db As ADODB.Connection
Dim sql1 As String

Set db = Application.CurrentProject.Connection

sql1 = "select * INTO tblContracts IN '" & dbloc & "ReviewQ1-1078.mdb ' from qryContract_Final_Output WHERE [MGR MKT LOC]=1078"


db.Execute (sql1)

set sql = nothing
set db = nothing
end sub


Just change the * to the fields you want to append.


Hope this helps!

Dan