SQL Loader problems

From: Colin Young <x_at_nospam.com>
Date: 1997/07/01
Message-ID: <01bc864b$e0bf8bd0$282a4018@colin>#1/1

I'm trying to import some data from a comma delimited file (actually, I have it in Excel, so the format can be changed) into an Oracle table using SQL Loader. Out of 64 rows, only 13 import correctly and the rest tell me:

"Record 13: Rejected - Error on table TEMPIMPORT, column DESCRIPTION. Field in data file exceeded maximum specified length"

The field is going into a varchar2(2000) column in the destination table, and at least some of the rows that give the error are definitely less than 2000 characters.

Any ideas (including alternate methods to get the data in)?

Thanks

Colin Young
cyoung_at_ceogroup.com Received on Tue Jul 01 1997 - 00:00:00 CDT