Odd data/time data reading empty cells from Excel Spreadsheet with RPG2SQL Integrator
From Support
| | If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
If you are reading from an Excel Spreadsheet and in cells where there is no data and you are recieving default Date/Time data in your program. Example: January 1, 1900 00:00:00
[edit]
Solution:
Your column headings were two lines and the rows 1 and 2 were merged. Delete one of the heading lines and that should fix it.
