• Thanks for replying

    bulk insert sample1

    from 'D:\BEM_Source\Sample'

    with

    (

    rowterminator = '',

    fieldterminator= ','

    )