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.

Database defintion from an Excel Spec?

Have you ever been required to create a database with nothing but a specification in Excel?

Utilize SSAS for data predictions and classification using Excel

Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.

Simple Column Chart for Analysis Services Data

This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.