Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bulk Insert Data With Field Terminator Included Within f
Message
De
08/04/2003 12:59:15
 
 
À
08/04/2003 04:49:39
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00775011
Message ID:
00775149
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform