sp_configure
sp_configure 'show advanced options', 1
reconfigure
sp_configure 'Ad Hoc Distributed Queries', 1
select * from [Customers_A-F]
insert into [Customers_A-F]
SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=D:\Temp\;','SELECT * FROM [Customers.csv]')
sp_configure 'show advanced options', 1
reconfigure
sp_configure 'Ad Hoc Distributed Queries', 1
select * from [Customers_A-F]
insert into [Customers_A-F]
SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=D:\Temp\;','SELECT * FROM [Customers.csv]')