How can I merge two databases and tickets tables?
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]);"