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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining 2 tables?

Status
Not open for further replies.
mavog

mavog

IS-IT--Management
Jun 12, 2003
25
GB
Hi ,
I want to combine 2 tables ,wCompany and wCompanyOLD.
wCompany has the latest data but wCompanyOLD has 6 additional fields, but only a few companies have data in these fields. How does one copy these 6 fields into the new table (wCompany) if the Company name is the same in both tables?
 
Sort by date Sort by votes
Use an update query linking by the Company Name
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
205
Dan Stoica
Dan Stoica
bobbyer
  • Locked
  • Question
Ms Access VBA Automatic Relinking Frontend to 2 Backend via form
Replies
13
Views
352
bobbyer
bobbyer
03Explorer
  • Locked
  • Question
Run StoredProc from Access to populate local holding table pt 2
Replies
14
Views
180
Andrzejek
Andrzejek
tbclbd
  • Locked
  • Question
Export Access tables to CSV file - records need to have varying record lengths
Replies
1
Views
81
Darrylles
Darrylles
03Explorer
  • Locked
  • Question
Using 2 numeric variables in a string variable for nested loops
Replies
9
Views
125
03Explorer
03Explorer

Part and Inventory Search

Sponsor

Back
Top