OpenRowSet-Bulk

SELECT BulkColumn
FROM OPENROWSET (BULK 'c:\temp\SampleAsciiCode.txt', SINGLE_CLOB) MyFile

SELECT BulkColumn
FROM OPENROWSET (BULK 'c:\temp\SampleUnicode.txt', SINGLE_NCLOB) MyFile

SELECT BulkColumn
FROM OPENROWSET (BULK 'c:\temp\SampleXML.xml', SINGLE_BLOB) MyFile

SELECT *
FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'text;Database=C:\;HDR=NO', 'SELECT * FROM sample.txt')