sqlpowershell.blog
T-SQL – Read CSV files using OpenRowSet
We can directly access a CSV file using T-SQL. Input file Configure server to run Ad Hoc Distributed Queries sp_configure ‘Ad Hoc Distributed Queries’,1 GO reconfigure GO Check for Micr…