akawn.com
Query and update an Excel 2010 spreadsheet via a linked server
This took a while to get working so I thought I’d list the steps taken to achieve manipulating an Excel 2010 spreadsheet via a linked server. The SQL Server I used was SQL Server 2008 R2 (64…