I then have a second excel worksheet with the owners in column A and their total cost for cars in column B. These 2 worksheets are not in the same order and some owners with bills do not show up in the first excel workbook with addresses.
What i want to do is match up all the owners in workbook 2 that are in work book 1. The eventual result would be a table that has
owner cost cars
I know this is very basic but I cant figure it out. There are over 13000 owners so I cant do it by hand. Any information will help. I have a basic understanding of access but from what i understand you cant create a relationship between 2 tables unless they are the same size and these 2 tables are not even close to being the same size. I have access 2003 and excel 2007.