Hello :

I am using bcp to load data from text file to a temporary
table in sql server 6.5 ( by running load.bat from dos prompt )

Contents of try.txt file ( Total 5 fields )
(4) charcter fields are put in quotes
and (1) numeric field ( does not have quotes around it )

"0000777376676570",1.01,"10021998" ,"111","abc"

My load.bat file is as follows :

bcp MANISH..TEMP in c: ry.txt -c -t, -Usa

MY OUTPUT to the temp table in sql server is as follows :

CharFld1 "000077737667657
NumFld2 1.01
CharFld3 "10021998"
CharFld4 "111"
CharFld5 "abc"

PROBLEM : Quotes should not be transferred into the temp table.

If I remove the quotes(&#34 from the try.txt file it works fine.


Manish Mehta