Is there a way to combine 2 tables into 1 table besides copying and pasting records? Both tables have the same field names and data types. I can't seem to find a way to export data between tables and it takes a long time to copy and paste a large amount of records. Any suggestions, please?
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combine tables with same field names?
- Thread starter crys333
- Start date
Go into the QBE screen and drag in the from table. Test your select extracts the records you want. Then change the query to an append query citing the target table as the table to append. Access will fill in all the field names as they are the same in both tables. Press the button.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
