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