How to Create sql table from CSV/TXT file

DECLARE @FilePath NVARCHAR(100)
CREATE TABLE #TempProcessFile
(

REFID NVARCHAR(100),
BatchId NVARCHAR(100),
TransactionID NVARCHAR(120)

)
/*
Suppose the data in ur CSV/txt file is as following. -CityList.txt

"city","state","country"
"Tirana","AB","Albania"
"Durres","","Albania"
"Vlore","","Albania"
*/

SET @FilePath = '\\kavita\Shared\CLearTrip\CityList.txt'--or ur csv format goes here

exec('BULK INSERT #TempProcessFile FROM ''' + @FilePath + ''' WITH ( FIRSTROW = 1, FIELDTERMINATOR = '+''',''' + ', ROWTERMINATOR = '+'''\n'')')
--print('BULK INSERT #TempProcessFile FROM ''' + @FilePath + ''' WITH ( FIRSTROW = 1, LastRow = 10 , FIELDTERMINATOR = '+''',''' + ', ROWTERMINATOR = '+'''\n'')')

select * from #TempProcessFile
DROP table #TempProcessFile