SQL Server: New Linked Server from Excel

Categories: Database; Tagged with: ; @ September 13th, 2012 19:50

We can create a new linked server using Excel:

image

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$;

<->



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.