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
coding + sharing = influence
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