Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE

In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.

The Best of Both Worlds: Using Excel and Power BI Together

Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.

Export data from SQL Server to Excel

What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.

Excel File Data Validation for SQL Server Imports

Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.

Power tools

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)

Moving Data From Excel to SQL Server - 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains.

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.

Set Up Grouping Intervals for Excel (SQL Spackle)

So you want to group your data for charting in Excel? Here's how, the easy way!

SQL Server Data Mining with Microsoft Office Excel

This article demonstrates using SQL Server's data mining capabilities with the Excel.