Excel Import Problem

Is there a method for checking what has changed from one excel to another. You see, I built this function in Access using a macro to import an excel file into access. I used a proto type excel file to test the import process. Which still works fine on the proto type. However, the finished copy of the excel file will even allow an import into the temp table, directly or indirectly.

I am now stuck and need to test the original and final version copies of the excel file to see what if anyhting has changed. That may be causing the problems.

Is this possible?

Thanks,....

Hi
you may have a look at

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla (http://www.cpearson.com/Zips/Compare.ZIP)

to compare two worksheets


--
Regards
Frank Kabel
Frankfurt, Germany


Russ wrote:
Is there a method for checking what has changed from one excel to
another. You see, I built this function in Access using a macro to
import an excel file into access. I used a proto type excel file to
test the import process. Which still works fine on the proto type.
However, the finished copy of the excel file will even allow an
import into the temp table, directly or indirectly.

I am now stuck and need to test the original and final version copies
of the excel file to see what if anyhting has changed. That may be
causing the problems.

Is this possible?

Thanks,....