SQL Server read text directly

1)OpenRowset, text driver
SELECT *
FROM
    OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:/;Extensions=CSV;', 'SELECT * FROM test.csv')

/*
content of test.csv:

OrderID,OrderDate,CustID,Amount
0001,2007-01-02,ABC,10000.00
0002,2007-01-03,ABC,12000.00
0003,2007-01-03,JCK,3000.00
0004,2007-01-05,TSH,56000.00

*/


2) OpenRowset, bulk mode
DECLARE @CSVfile VARCHAR(MAX)
SELECT  @CSVfile = BulkColumn
FROM    OPENROWSET(BULK 'C:/a.txt', SINGLE_BLOB) AS x
SELECT @CSVfile

3) OLE Automation
sp_OACreate  'Scripting.FileSystemObject'