combine two tables into one.

[chad740]

Hi all Im new to access. I have takin two excel files I have and imported them into access. One is called employees and the other one is employee list. employees table has info like address, Email, Date of birth, Hire Date ect. The Employee list has different info like Home phone, Cell Phone, Email and job title. I want to combine the two together and only have one without typing all the info from the smaller table to larger table. I want to join them by looking up the Email address and putting the cell phone num home phone and job title with the correct person.. Is this possible? Ive already created these new fields in the larger table i just need to get them moved from the small one now.. thanx for any help very new to access so be easy..

[orange]

see http://www.techonthenet.com/sql/update.php

[chad740]

thank you ill try that..