It's possible but not easy. You'll have to create a BCP style format file and include it in the call to BULK INSERT (FORMATFILE parameter). The file will have to be customized as described in this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;132463.

One trick I use - instead of creating a format file manually, I go to DTS Designer, create a Bulk Insert Task and have it create the format file for me. Once you have the format file generated, you can customize it as described in the KB article.

Roman


>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