Join Excel tables across directories

Is it possible to join two excel tables from workbooks in separate file locations together? For example, this is possible:

Join these two tables.

C:\LocationA\workbook1, [workbook1].[Sheet1]

to

C:\LocationA\workbook2, [workbook2].[Sheet1]

But I can't seem to make this join work:

C:\LocationA\workbook1, [workbook1].[Sheet1]

to

C:\LocationB\workbook2, [workbook2].[Sheet1]

Even if I add both directories to the Location section of the server properties. Thank you for your time!

Parents Reply Children
No Data