B B McGill Sep 16, 2003 #1 Can someone please tell me how to write an append query to bring data from one table into another. tks
Can someone please tell me how to write an append query to bring data from one table into another. tks
K Ken Snell Sep 17, 2003 #2 Help file has some examples. Can you give us more info about what you want to do? Standard syntax is INSERT INTO tblName ( Field1, Field2, Field3 ) SELECT [OthertblName].FieldName1, [OthertblName].FieldName2, [OthertblName].FieldName3 FROM [OthertblName];
Help file has some examples. Can you give us more info about what you want to do? Standard syntax is INSERT INTO tblName ( Field1, Field2, Field3 ) SELECT [OthertblName].FieldName1, [OthertblName].FieldName2, [OthertblName].FieldName3 FROM [OthertblName];