Post reply

Importing .CSV into 2005 vs 2000

  • March 10, 2009 at 6:07 am

    #956698

    There is a Text qualifier box on the General tab of the FlatFileSource Import wizard. Defaults to none but you can just type the double quote in there.

    Also choosing a delimited format should allow the wizard to 'have a go' at defining the columns.

  • March 10, 2009 at 9:00 am

    #956864

    I think that did it, thanks. I had put a double quote in their twice, but should have put just one.

  • April 22, 2009 at 4:47 pm

    #982601

    You need to assign the Text qualifier as " (double quote) while creating the flat file source connection for CSV file.

    Thanks.

    Gunjan.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply