Import csv into SQL Server without need of format file

import csv into SQL Server no format file.sql

INSERT INTO [YOURLINKEDSERVER].[YOURDB].[DBO].YOURTABLE
	SELECT
		*
	   ,cast('2017-05-20' as date)
	FROM OPENROWSET('MSDASQL'
	, 'Driver={Microsoft Access Text Driver (*.txt, *.csv)};
DBQ=C:\first_directory\second_directory\'
	, 'select * from "your_file.csv"')