Post reply

CSV data import by using BULK INSERT with Format file.

  • September 7, 2011 at 7:49 pm

    #390362

    Hi,

    I was trying to import data from a CSV file by using BULK INSERT. For that, I have created FMT file. But it is throwing error as below. Where I did wrong?

    Msg 4866, Level 16, State 7, Line 1

    The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.

    Msg 7301, Level 16, State 2, Line 1

    Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

    Please find the attached SQL script file, CSV file, and FMT file.

    Files attached:-

    1. SQLScript.txt

    2. cm07SEP2011bhav.txt - This has to be renamed to cm07SEP2011bhav.CSV

    3. cm07SEP2011bhavfmt.txt - This file has to be renamed to cm07SEP2011bhavfmt.fmt

    Thanks in Advance

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

Viewing post 1 (of 1 total)

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