Match

[nishkrish]

I have 2 different files in one i write the number physically that i have
downloaded from website i need to compare that number with one which i have
written with the one i have downloaded. and they are in two seperate files.

Basically i want to see if it matches cause it might not be in the same
order that i have entered it should show column a10 of sheet 1 matches with
column d15 of sheet 2.

If i bring the excel to access is it possible to do this in access.

 

[KARL DEWEY]

Access does not use sheets and columns. It uses tables and fields.I do not follow the above. Do you mean one may read 1234 and the other
2341?
Post an example of what your data might look like.

 

[nishkrish]

No i meant was they both read as 12345 the only thing is its 16 digit long
only thing that wont match is last digit

 

[KARL DEWEY]

As I sais Access uses tables and fields. You did not say anything about them.

Use an unmatch query.