• terry999 (7/31/2014)


    Thanks

    Where do I put the -c I tried

    BULK INSERT tBCP FROM 'C:\temp\tbcp.csv'

    WITH (FORMATFILE='C:\temp\fmt.fmt', DATAFILETYPE='char')

    It doesn't work

    Ooops, my bad, I was thinking in bcp:-P

    Should be DATAFILETYPE = 'char'

    😎