I am trying to append records from one table to another in vba using an SQL string. The only difference between the two tables is that the target table has one additional field from source table. This is the SQL generated from the Query Expression Builder:
INSERT INTO Bloomin_Transmission_History_File
This works fine either run as a query or in VBA.
My question is that "Bloomin_Transmission_History_File has one additional Text Field that I want to populate with the value of a string variable named: ExpFName. the Field Name I want to update with this variable is: [Transmission File Name]