Permalink
Cannot retrieve contributors at this time
-- Note: Requires the driver to be installed ahead of time. | |
-- list available providers | |
EXEC sp_MSset_oledb_prop -- get available providers | |
-- Enable show advanced options | |
sp_configure 'show advanced options',1 | |
reconfigure | |
go | |
-- Enable ad hoc queries | |
sp_configure 'ad hoc distributed queries',1 | |
reconfigure | |
go | |
-- Write text file | |
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=c:\temp\;HDR=Yes;FORMAT=text', 'SELECT * FROM [file.txt]') | |
SELECT @@version | |
-- Note: This also works with unc paths \\ip\file.txt | |
-- Note: This also works with webdav paths \\ip@80\file.txt However, the target web server needs to support propfind. |