-
BCP Quotes problem
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(" from the try.txt file it works fine.
Manish Mehta
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|