Following message is generated when "is not a valid integer value" when trying to import excel file into Toad for Oracle.
Excel file date columns are not formatted correctly.
WORKAROUND:
1. Open the file in Excel.
2. Click a column heading of a date column to select all cells in that column.
3. Right mouse click the column and click Format Cell.
4. For Category, select Date. Select another date type, such as mm/dd/yy.
5. This will reformat the date for the entire column and likely fix the corruption.
6. Repeat steps for all columns that contain a date.
7. Save the file with another name and retest the issue.
