Post reply

Text File Import

  • 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?

  • 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

  • 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.

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

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