Import problem

B

Bill Watson

I import several Excel spreadsheets into various tables
after being downloaded from an AS/400 without problem.
I am now creating an enhancement to the Db and would like
to have users be able to manually change some fields after
download from AS/400 and prior to import into Access.
While testing I find that some fields in records not
manipulated are somehow changed.
An example is:
Spreadsheet A is imported into table A containing Invoice#
and Amt.
Some row's amt fields in Spreadsheet B are changed to 0
and imported into table B also containing invoice #'s and
amts for the most part identical to table A.
I then need to join on invoice# and amt for export and
upload back up to the AS/400.
The problem I am getting is that in some unchanged records
the Amt fields in table B are not equal to table A even
though the Amt is identical and the tables are structured
identically.
For the most part the amts do equal and the export works
as expected for those records.
Does anyone have an idea what could be changing just a few
amt fields in table B?

Thanks,
Bill
 
Top