Compare 2 spreadsheets

  • Thread starter Thread starter Alex Lifeson
  • Start date Start date
A

Alex Lifeson

I have an Access application that compares 2 .xls files (one from an old
system, the other from a new system).


I compare both spreadsheets, row by row, cell by cell.

Is there a way (property?) to get the "formatted" value of a cell (ie what
you actually see). My application fails on the following example.

Spreadsheet Value Format What you see

Old .08167 Percent (1 Decimal) 8.2%
New 8.2% None 8.2%


I could put code in my application that multiplies the values in the "old"
spreadsheet times 100 and Round to 1 decimal place.

Thanks in advance for your help.
 
Dear Alex:

Good question. I don't know the answer.

Would this work? Copy and paste the spreadsheet into a table with text
columns. Do the values then appear as needed?

Comparing formatted information is comparing text, not numeric values, as
your post implies. But the formatting itself must be comparable for that to
work.

Is it too much work to copy and paste? Do you want the database to format
it so it can compare the way you expect? You'd have to build similar
formatting into the comparison query I expect for that to happen.

Tom Ellison
 
Back
Top