access query

[Guest]

I need to create a query comparing 2 excel spreadsheets where the contents of
1 sheet are not found in the other spreadsheet.

 

[maurrieske]

why not working in Excel itself with te Vlookup formula?

Maurrieske

 

[Guest]

new to both access and excel will 'lookup' give me what I want?

 

[Guest]

new to both access and excel how do u "lookup"?

 

[Guest]

not finding Vlookup in the excel for dummies book

 

[maurrieske]

Make a new excel workbook.
Copy the sheets from the to excel files you want to compare to this new
workbook. Name one sheet CS_1 and th other CS_2.
Then add two new sheets to this workbook. Name these sheets CS_1_check and
CS_2_check
Put in range A1 on sheet CS_1_check the following formula
=VLOOKUP(CS_1!A1,CS_2!A:A,1,0)
copy this formula to the same range then there are values to compare on
sheet CS_1
All cells with a #N/B as a result are in the sheet CS_1 but not in the same
column in sheet CS_2


Then put in range A1 on sheet CS_2_check the following formula
=VLOOKUP(CS_2!A1,CS_1!A:A,1,0)
also copy this formula to the same range then there are values to compare on
sheet CS_2
All cells with a #N/B as a result are in the sheet CS_2 but not in the same
column in sheet CS_1

With this formula you should get wat you want.

Maurrieske

 

[John W. Vinson]

On Mon, 20 Aug 2007 09:34:01 -0700, Anthony King <Anthony

I need to create a query comparing 2 excel spreadsheets where the contents of
1 sheet are not found in the other spreadsheet.

What's the structure of the datasheet? How do you define a "match" or a
"mismatch" - one field? several fields? all the fields?

You can use File... Get External Data... Link to connect to the spreadsheets,
and use the "Unmatched Query Wizard" on the new Query window if it's a
straightforward one-field match. If you need more, post back with more info.

John W. Vinson [MVP]