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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
New to MS Access
- Thread starter Steve95
- Start date
- Thread starter
- #3
Steve,
You can either import it using the Menu File|Get External Data|Import. Then once imported you can take the new table and create a new query, choose Design View, then in the Show Table dialog that will come up, add the new table to that query. Then on the Query menu choose Append, then in the Table Name dropdown you choose the original table that already has the records which you want added to.
Then it's a matter of mapping the fields--if the fields are named the same in the original table as in the new one, this will be done automaticially, else look in the "Append To" row of the query grid and choose the proper field for the one at the top of that column from the new table.
--Jim
You can either import it using the Menu File|Get External Data|Import. Then once imported you can take the new table and create a new query, choose Design View, then in the Show Table dialog that will come up, add the new table to that query. Then on the Query menu choose Append, then in the Table Name dropdown you choose the original table that already has the records which you want added to.
Then it's a matter of mapping the fields--if the fields are named the same in the original table as in the new one, this will be done automaticially, else look in the "Append To" row of the query grid and choose the proper field for the one at the top of that column from the new table.
--Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question