Re: "...The file I am importing is comma delimited text ..."
I believe the default separator is the vertical bar (virgule, "|"), but
as Igor wrote, you can easily change it with:
.separator ,
I *don't* think you can quote commas which might appear in your text.
E.g. if you are importing a list of names, you can just surround the
name with quote chars, such as:
"John Smith, Jr.",Anytown,USA
So if your text contains commas, you might want to use a different
separator.
Also, I don't think a trailing separator character is expected at the
end of your records. If your originating application insists on
including one, you can just define an extra field on your import table.
[opinions are my own, not those of my company]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
