Trouble with Import Wizard: "Input array is longer than number columns in this table" (4273724)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Trouble with Import Wizard: "Input array is longer than number columns in this table"
Description

When using the import wizard, I add a file (*.CVS), selected comma delimited file format, and select Next. An error appeared: "Input array is longer than number columns in this table".
Cause

The original file uses Unix 'LF' format (0x0A) but we expect Windows 'CRLF' format (0xD0A).
Resolution

WORKAROUND:
Open a file using Excel and save the file back as CSV file.

STATUS:
Waiting for enhancement on a furture release of Toad for DB2.
Defect ID

ST52558

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title