Link to home
Create AccountLog in
Avatar of Mike Treat
Mike TreatFlag for United States of America

asked on

Bulk Import:Remove text qualifier Double Quotes while importing

Hello,
I am importing .dat file which has double quotes (")  as the text qualifier.I am able to successfully import the bulk data courtesy the msdn link  "http://msdn2.microsoft.com/en-us/library/ms179250.aspx."
But the problem i am facing is that the text qualifier is also getting imported in my table..Something like  "2258101005"      " INC      SE NE 123456" etc etc

So i am looking for a solution how i can remove it by doing modification in my format file.

Thanking You
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.