Text File Import

• greedhu

  SSC Rookie

  Points: 32

  More actions

  June 12, 2003 at 6:27 am

  #175955

  I am importing a text file with <CR><line Feed> as the end of line parameter. This drops the last line, which does not have these charecters. Any way to get around this other then adding a "dummy" line?

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 12, 2003 at 6:54 pm

  #461190

  I usually use bulk insert to perform quick imports

  I don't know what you're using but try this

  Bulk Insert (Table_Name) From 'Input_FilePath'

  With (FieldTerminator = 'Field_Delimeter',

  RowTerminator = 'Row_Delimeter'

  )

  Or you can try simply replacing your line end params. with '\n'

  MW

  Edited by - mworku on 06/12/2003 9:00:55 PM

  
  MW

• j.o.s.

  Ten Centuries

  Points: 1242

  More actions

  June 14, 2003 at 7:01 pm

  #461433

  Do not forget to use the tablock parameter to improve performance whilst using the bulk insert statement.