Just a WAG here, but it sounds like one of the records in the DAT file does not have enough delimited fields to meet the field list in the CTL file. If this is a large DAT file, you might try creating a cursor [or table] in VFP, do an append from delimited. Then do a copy to delimited. This should get enough commas into the DAT file so every record meets the CTL field list definitions.
>I am trying to import data with sqlldr80, and keep getting the following:
>SQL*Loader-524: partial record found at end of datafile (g:\~\load_docs.ctl)
>
>a) thats not the data file, ok, go to b
>b) all records appear to be present, each with all 15 fields
>The provided documentation say NOTHING about the error, in fact I can find no listing of SQLLoader errors anywhere. As far as I can tell there is no problem with the ctl file (this is the first time I've tried this)
>I get the same thing with sqlldr80 uid/pwd control=load_docs.ctl as I do with parfile=load_doc.par
>HELP!!!
Mark McCasland
Midlothian, TX USA