Guest_imported
New member
- Jan 1, 1970
- 0
What would the syntax be for append records between two tables with the same structure.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Append records from one table to another
- Thread starter Guest_imported
- Start date
- Status
MichaelRed
Programmer
Insert Into [DestTbl] (Field List ... ) Select [Source table Field List] From [SourceTable]
"(Field list )" is a comma & space delimited list of the field names where the data is appendes. e.g.:
MyField1, ThatField2, ...
"[Source table field list] is similar - except that it needs to include the source table name. e.g.:
TblA.YourField1, TblA.thatfield2, ...
The two field lists MUST be in the same ORDER!
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
"(Field list )" is a comma & space delimited list of the field names where the data is appendes. e.g.:
MyField1, ThatField2, ...
"[Source table field list] is similar - except that it needs to include the source table name. e.g.:
TblA.YourField1, TblA.thatfield2, ...
The two field lists MUST be in the same ORDER!
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question
