Hello,
Client Access comes with an add-in that allows one to transfer an excel sheet to the AS400. I am using Client Access 5.5 however, and if I attempt to transfer an excel sheet where a column is in a mm/dd/yyyy date format, the file transfer converts it into a numeric (non-date) value. The "transfer-to" wizard walks thru all of the steps, but when it scans the excel file, it thinks that the date column is numeric.
Has anyone ran into this before?
- Kevin
Client Access comes with an add-in that allows one to transfer an excel sheet to the AS400. I am using Client Access 5.5 however, and if I attempt to transfer an excel sheet where a column is in a mm/dd/yyyy date format, the file transfer converts it into a numeric (non-date) value. The "transfer-to" wizard walks thru all of the steps, but when it scans the excel file, it thinks that the date column is numeric.
Has anyone ran into this before?
- Kevin
Comment