Post reply

Insert entire line into one column of the table

  • October 21, 2014 at 7:47 am

    #297676

    I convert EBCDIC file to text file at C:\order\order.txt. There are about 1400000 rows. The length of line is 1500.

    How to insert entire line into one column of the table? (only one column, named as [LineDetail])

  • October 21, 2014 at 8:45 am

    #1753774

    Create a table with a varchar of 1500 (or more) in length. You can insert with BULK INSERT or SSIS (or the import wizard). Map each line, no delimeter, to the column.

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

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