How to Copy or Import 'selected fields' from one table to another?

W

Will

We have two tables... tblOld and tblNew... both in the same data base

we want to copy or Import certain fields in tblOld to selected records in
tblNew

the records in tblNew are already created and a couple of fields are already
populated properly

we want to...
- select a set of records in tblNew
- select a set of records in tblOld
- select the fields in tblOld we want to copy or import into tblNew
- the field names in both tables are the same

Thanks for any help on how to do this.
 
P

pietlinden

We have two tables... tblOld and tblNew... both in the same data base

we want to copy or Import certain fields in tblOld to selected records in
tblNew

the records in tblNew are already created and a couple of fields are already
populated properly

we want to...
- select a set of records in tblNew
- select a set of records in tblOld
- select the fields in tblOld we want to copy or import into tblNew
- the field names in both tables are the same

Thanks for any help on how to do this.
Click to expand...

join the tables and create an update query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining tables 4
add data from other table 2
Trying to Understand Update Queries 6
strange error message following INSERT INTO statement 5
Copy records from one table to another 2
Import table from one db into another 5
Import table error 6
Importing from Excel to a droplist field 1

Top