Post reply

import data using DTS bulk insert or BCP

  • August 14, 2003 at 3:28 am

    #81012

    hi there,

    I have a problem when i want to import a large ASCII/text file to SQL.

    I used format file, and I select option "First Row is column header" option when generate format file. But it didn't work, it still read form the first row.

    can anyone help me ?

    thanks,

  • August 14, 2003 at 3:41 am

    #469886

    If you are using BCP there is a parameter -F which determines the first row to import. There is a similar option for Bulk Insert in an SQL Statment.

    Jeremy

  • August 14, 2003 at 8:25 pm

    #470047

    thanks... what if I'm using DTS ?

    what should I write in format file to tell SQL, there is a column header ?

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

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