My select don't work properly (problem in the picture). I use SQL Server 2008r2.
select * from OpenRowset('MSDASQL',
'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=D:\MALEP_BCP\CSV_VSND\;Extended properties=''HDR=YES; FMT=Delimited(;)''',
'select * from pokus.csv')
With schema.ini work OK.
But I need use various delimited and defined in SQL.
Help me pls.