Import From Text File - Invalid Argument error

[pavithra]

I have tab delimited text file with some 155 columns. When I try to import it
into an existing table using the import wizard it gives me an 'Invalid
Argument' error. But when I do the same import after converting the text file
to an excel file , it works fine. I tried to import, after the changing the
data in the text file to be of the same datatype as that in the table
specification. But even now it gives the same error but works in excel.

Any idea why this error occurs and how to avoid it?

 

[Madhivanan]

Pavithra,
Your text file may contain new line charaters whereas in Excel you dont
have

Madhivanan

 

[pavithra]

Is it possible to remove the newline characters from the text file??Instead
of an excel, is there any workaround to import from the text file??When using
the excel file i have arestriction of 65535 records only at a time. So I
would prefer using a text file only. Any solns?