none
flat file

    Question

  • hi

    i have 1 csv file which has all the values like "1",

    when i upload the file ,i am getting "1" in the database.i want to remove "" ,

    if i place "" in text qualifier, it shows me error like

    please help me

    Wednesday, November 21, 2012 6:57 PM

Answers

  • The text qualifier property must be set to a single double quite - " not two ("").

    Arthur My Blog

    • Marked as answer by tsql_new Wednesday, November 21, 2012 8:40 PM
    Wednesday, November 21, 2012 7:09 PM
    Moderator