The basic code I have as below, to merge Tickets1 table into Tickets table, provided you brought in Tickets1 via Get External Data..

How would I merge database on c:\dir1\event.mde (table tickets) into f:\dir3\subdir\event.mde (table tickets)?


Private Sub Command1_Click()
''INSERT INTO maintable SELECT * from temptable WHERE someidfield NOT IN (select someidfield FROM maintable)
Dim strLogs As String

strLogs = "INSERT INTO [Tickets] SELECT * FROM [Tickets1] WHERE [TicketID] NOT IN (SELECT [TicketID] FROM [Tickets]);"
DoCmd.RunSQL strLogs
End Sub

aCk!

__________________
aCk!

I found out I could do the TransferDataBase and export, but it replaces the table instead of merging them..

help please.

aCk!

You should link one of your tables in the other database file. Create a append query. This should allow you to append the records from table A into table B.

[LGuzman]