OPENROWSET (Txt File)

February 21, 2018February 21, 2018 marifnst SQL Server Leave a comment

SELECT * 
FROM OPENROWSET
(
'Microsoft.ACE.OLEDB.12.0', 'Text;Database=<txt or csv path>;HDR=YES', 
'SELECT * FROM <file name>'
)