Connect to a .csv file via stored procedure in MS SQL server

1. bulk insert [table] from 'C:\tmp\file.csv' with....
2. select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\tmp;','select * from file.csv')
3. exec sp_addlinkedserver @server="MyText", @srvproduct="", @provider="MSDASQL.1", @provstr="Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\tmp"