SQL Server: New Linked Server from Excel

Categories: Database; Tagged with: SQL • SQL Server • T-SQL; @ September 13th, 2012 19:50

We can create a new linked server using Excel:

Select the Provider, Input the data source(excel path), and provider string, keep ‘Excel 8.0’.

Save, and you can see the server .

then you can query from the new server:


SELECT * FROM DAVIDEXCEL...Sheet1$;