Information générale
Forum:
Microsoft SQL Server
Titre:
Bulk insert cmd includes Double quotes in character strings
Hi,
I am impotring data from a txt files into an sql database using bulk insert command. Character fields are enclosed in "(double Quotes).
After Importing The Data i see that the double quotes are also included in the fields.
How Can i avoid this without using a format file?
Here is an example of my bulk insert command :
DECLARE @cPATH VARCHAR(200)
SET DATEFORMAT dmy
SET @cPATH= '"C:\Imdbcy\DBIMDB\output\Chrvalues.txt"'
EXEC ('BULK INSERT IMDB..ChrValues FROM '+@cPATH+' WITH (CODEPAGE=''RAW'',DATAFILETYPE=''CHAR'', FIELDTERMINATOR = '','', ROWTERMINATOR =''\n'',KEEPIDENTITY)')
Tnx
Anthi
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement