How to Read CSV file in SQL Server 64 bit

This is example how to read CSV file using SQL Server 64 bit :


SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Text;Database=E:\SUPM\Reports\2014\Weekly\39\Source\Data OSS\;HDR=YES',
'SELECT * FROM 20140929_DataOSS_2G_clean1.csv')


Enjoy