Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bulk Insert Data With Field Terminator Included Within f
Message
From
08/04/2003 12:59:15
 
 
To
08/04/2003 04:49:39
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00775011
Message ID:
00775149
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform