How to insert data in table by sp with csv,txt,xls file?

BULK INSERT MyTable
    FROM 'e:\data.csv'
    WITH
    (
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'
    )