You ll have to use a different driver to connect to csv file.

This is new command :

select * from OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Temp;Extended properties=''ColNameHeader=True;Format=CSVDelimited;''','select * from Test.csv')

If you want more formating you ll need to use a schema.ini file

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

schema.ini (same folder as Test.csv file!)

[test.csv]

ColNameHeader=True

Format=CSVDelimited

MaxScanRows=25

CharacterSet=ANSI

Col1=COL1 Char Width 255

Col2=COL2 Char Width 255

Regards,

Vasc