Dynamically using openrowset through to more formally with Linked Server. Could even go to Office Automation procedures - but we won't go that far if not needed.

To open the SQL .BAK files in Excel, locate the .bak file on your hard drive, right-click it and select & rename it with XLS file extension.

Generates a table, with data, on a SQL Server instance, based on information extracted from an Excel Spreadsheet.

How SQL Server fits into this solution – One of SQL Server 2012’s most significant differentiators to help enterprises handle large datasets from SQL Server 2008 is its compatibility with Hadoop.

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

Last week, we announced the availability of the SQL Server 2008 R2 November CTP. Today we are excited to share that the SQL Server 2008 R2 PowerPivot downloads for Microsoft Excel 2010 and Microsoft ...