Forum Replies Created

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

  • RE: How to differentiate (Field containing comma) in csv file while using bulk insert

    My table Sructure is as follows

    Create Table [##Table] (UHRZEIT Varchar(100),RUFNUMMER Varchar(100),DAUER

    Varchar(100),BETRAG varchar(100),Note Varchar(100),URSPRUNG Varchar(100),ZIELORT Varchar(100))

    Contents of my CSV File is as below:

    First line is Header.

    UHRZEIT,RUFNUMMER,DAUER,BETRAG,Note,URSPRUNG,ZIELORT

    8:09:15,9.14E+11,0:01:34,"23,333",Actual cost = PurchaseCost/10000,,Indien

    11:03:36,9.20E+11,0:04:43,"67,667",,,Indien mobil

    15:53:53,9.20E+11,0:04:18,"60,667",,,Indien mobil

    18:01:03,9.14E+11,0:03:13,"46,667",,,Indien

    5:17:27,9.14E+11,0:00:13,"14,000",,,Indien

    5:17:55,9.14E+11,0:00:10,"14,000",,,Indien

    5:18:43,9.20E+11,0:02:37,"37,333",,,Indien...

  • RE: How to differentiate (Field containing comma) in csv file while using bulk insert

    my field is like "Field"(Surrounded by "").But how to make BCP Format .

    Pls guide me.

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