How to link up information from two excel docs

[#1]

I have employee ID in 1 excel spreadsheet, along with other bits of informaiton about machinery

and another spreadsheet with the names for corresponding employee ID's

I'm trying to create a pivot table which uses employees names correlated to information about machinery, rather than using employer ID.

[danieloberbilli]

When loading both tables, ensure that the Employee ID field is written in exact the same way in both tables - you can rename the fields like e.g.

File1:

LOAD

[employee ID] as EmployeeID,

...

from...file1

File2:

LOAD

EmpID as EmployeeID,

...

from ....file2

[#3]

Please provide sample data..