How to create a format file for below records?

• sharma-691993

  SSCrazy

  Points: 2194

  More actions

  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

• Bob Pinella

  SSCommitted

  Points: 1737

  More actions

  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