How to query SQL Server insert data from file CSV with declare variable

Question

How to execute variable declare insert data from CSV file.

I have code like this but doesn't work

DECLARE @namafile nvarchar(100) ='E:\files\importdata.csv'

BULK INSERT tblimportmining
FROM '@namafile'
WITH
(
    FIRSTROW = 2,  
    FIELDTERMINATOR = ',',   
    ROWTERMINATOR = '\n',    
    TABLOCK
)