Post reply

Bulk Insert

  • July 20, 2005 at 6:41 pm

    #165401

    Hi,

    I ran this:

    BULK INSERT XXX.dbo.XXXXX FROM '\\YYYY\WWW\filename.txt' WITH (FIRSTROW = 2)

    and got an error:

    Server: Msg 4864, Level 16, State 1, Line 1

    Bulk insert data conversion error (type mismatch) for row 2, column 6 (SellInQty).

    when I tried to bulk insert a file.

    The import file has 2 less columns than destination table. Is there a work around? Many thanks.

    Chris

  • July 20, 2005 at 6:50 pm

    #575957

    You'll need to specify a format file to have less columns. Check the BULK INSERT command in Books Online for details.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 26, 2005 at 9:10 am

    #577206

    Or bulk insert to a staging table and from there do a TSQL INSERT INTO or whatever.

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

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