Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set-up a query in Access to review two excel spreadsheets for
matching information?
 
No guarantees, but...

Link the two spreadsheets to the Access Database. Create a query and add
the two spreadsheets as tables.
 
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.

--
 
Back
Top