Access Query

R

ROXANN

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

[MVP] S.Clark

No guarantees, but...

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

Jamie Collins

ROXANN said:
How do I set-up a query in Access to review two excel spreadsheets for
matching information?
Click to expand...

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.

--
 
Top