I have been handed some Excel spreadsheets with long lists convert to access.

Neither one has an ID field but both spreadsheets have a common CUSTOMER NAME.  CustomerName will now be a field

Essentially want to merge the two lists, 2 spreadsheets into a single table.

Table1: will be my master table
[CustomerName] [SalesmanName]... lots of other fields and multiple records of the same CusomerName with different info in other fields

Table2: only a list of:
[CustomerName] [SalesmanName]

If are familiar with Excel and it's VLOOKUP this is very similar to what I want to do.  I want to update the Table1 with the specific info from Table2.

So, I created a form from Table1.  Then in Table1's SalemanName field, tried:
Dlookup("SalesmanName", "Table2","[CustomerName]=[CustomerName]"

So, 1) there are no CustomerID's   2)The text strings of CustomerNames are identical for Table1 and Table2

Am attempting to convert spreadsheets to Access Database.

There is a roundabout method of using the 2 Excel Sheets to make common CustomerID fields, then import the result into ACCESS.

Hopeing that there is a short cut method since the 2 spreadsheet Textfields are identical ... and hope that can serve as a proxy for a common ID field.

Make sense now?
Cheers
Tom

---

Reply from Alex Hedley:

You can join two Tables/Queries using any Field. So if text match in both and you join on that it will work, numbers are preferred just for efficiency.