Comparing with Access

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

At present I'm using Excel to compare two datasets using
the IF statement, i.e. IF a=b, true, false, but this can
take along time especially if the data is held on two
different sheets.

Can Access be used to do the same thing and if so, would
the calculation be quicker?
 
At present I'm using Excel to compare two datasets using
the IF statement, i.e. IF a=b, true, false, but this can
take along time especially if the data is held on two
different sheets.

Can Access be used to do the same thing and if so, would
the calculation be quicker?
Click to expand...

As a relational database, this is bread and butter for Access: you'ld
just create a Query joining the two tables. If you'ld care to post
some details of the nature of the data and of the comparison,
including how you'ld like to see the results, we'd be glad to help set
up this query.

And yes... it will be MUCH MUCH faster.
 
Back
Top