Post reply

How to create a format file for below records?

  • June 15, 2008 at 11:05 pm

    #381138

    How to create a format file for below records

    "AB1234" "12345" 30 no 40

    "AB1235" "12346" 40 no 50

    "AB1236" "12347" 50 no 60

    I am using bulk insert to load the records.

    I am using tab seperator.

    The values available in column 1 & 2 are inserted in table as "" quotes only.

    How to set in format file to ignore the quotes?

    Thanks

  • September 9, 2009 at 7:53 am

    #1051122

    I don't believe that you can use a format file to ignore quotes. It is simply used to map the columns from the data file to the SQL Table you are importing to. You may just want to import the data as is and then run a replace statement to remove the quotes. A good source of information for format files can be found here:

    http://msdn.microsoft.com/en-us/library/ms189327.aspx

    For sample format files:

    http://msdn.microsoft.com/en-us/library/ms191234.aspx

    Bob Pinella

Viewing 2 posts - 1 through 1 (of 1 total)

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