Thanks Mike. We have a work around on the client end this time.
I would like to make the record delimiter |{CR}{LF}, but no-o-o-o-o-o.
:-)Bob
>Bob,
>
>What about importing the data into a staging table that has an extra column at the end of the row?
>
>-Mike
Database Development Team