If you use comma delimited format, you can't have commas within the fields. You'll have to clean up your data first, use a different character as a delimiter or switch to tab-delimited format.
Roman
>Hi,
>
>How can i Bulk Insert Data With the Field Terminator Included Within a field?
>
>For example i want to bulk insert data from a comma delimited text file.
>What if i have a Character String in that file that contains a ,(comma) at the begining or in the middle or at the end or all three cases at the same time.
>
>My character Strings may also contain "(double quotes) And '(single quotes).
>
>What Should i Do to import this Data?
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729