Access Query

[Guest]

How do I set-up a query in Access to review two excel spreadsheets for
matching information?

 

[[MVP] S.Clark]

No guarantees, but...

Link the two spreadsheets to the Access Database. Create a query and add
the two spreadsheets as tables.

 

[Jamie Collins]

How do I set-up a query in Access to review two excel spreadsheets for
matching information?

You need to use one or more columns common to both as a key, something like:

SELECT T1.MyKeyCol, T1.MyDataCol
FROM
[Excel 8.0;HDR=YES;Database=C:\File1.xls;].[Sheet1$] AS T1
INNER JOIN
[Excel 8.0;HDR=YES;Database=C:\File2.xls;].[Sheet1$] AS T2
ON T1.MyKeyCol = T2.MyKeyCol
;

Jamie.

--