I try to transfer an excel file to AS400 vis client access.
In the excel file I have the numeric data in a character column.
I parameter the access to conver the numeric to character and it work.
My problem is when the numeric in excel has more than 6 digits like (6108312457) I receive in the as400 charater field a data like (6.10831E+009).
in the lower part you have a example of the excel file and the as400 result file.
Need you advice to receive the data like it was in the excel file (6108312457)
CUST# SKU# UPC#
1Q1005 912222-2 6108312457
Customer Code Customer SKU UPC Barcode
1Q1005 912222-2 6.10831E+009