Odd data/time data reading empty cells from Excel Spreadsheet with RPG2SQL Integrator - Support

Odd data/time data reading empty cells from Excel Spreadsheet with RPG2SQL Integrator

From Support

Jump to: navigation, search
If you have a question or seek clarification, please call Technical Support.

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

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.

Personal tools