OPENROWSET (Txt File)

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Afiseaza emoticoanele Locco.Ro