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...