SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Excel Rss

Search for any content tagged excel

<< Newer    Items 21 to 40 of 70    Older >>

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.  Read more...
By Additional Articles 2013/06/13 | Source: SimpleTalk | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 7,724 reads

More Uses for Data Explorer for Excel

Microsoft has introduced a new BI product that will help simplify the data discovery phase for Excel users. “Data Explorer” is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Data Explorer is a preview product so these features may appear differently in the final release.  Read more...
By Additional Articles 2013/06/07 | Source: MSSQLTips.com | Category: data explorer
Rating: (not yet rated)  Rate this |   Briefcase | 5,267 reads

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,774 reads

Using source data from an SSRS report in PowerPivot for Excel

In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.  Read more...
By Additional Articles 2013/05/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,403 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,779 reads

QlikView for Beginners - An Introduction to QlikView

A brief introduction to getting started with QlikView. 
By Mark O'Donovan 2012/12/17 | Source: SQLServerCentral.com | Category: qlikview
Rating: |  Discuss |   Briefcase | 3,207 reads

Stairway to DAX and Power BI - Level 2: The DAX COUNTROWS() and FILTER() Functions

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.  Read more...
By Bill Pearson 2013/09/11 (first published: 2012/12/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,712 reads

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel  Read more...
Rating: |  Discuss |   Briefcase | 5,971 reads

Importing Data From Excel Using SSIS - Part 1

Recently while working on a project to import data from an Excel worksheet using SSIS, I realized that sometimes the SSIS Package failed even though when there were no changes in the structure/schema of the Excel worksheet. I investigated it and I noticed that the SSIS Package succeeded for some set of files, but for others it failed. I found that the structure/schema of the worksheet from both these sets of Excel files were the same, the data was the only difference. How come just changing the data can make an SSIS Package fail? What actually causes this failure? What can we do to fix it?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,754 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,472 reads

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!  Read more...
By Dwain Camps 2012/07/31 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,246 reads

How to Name Sheets in Exported Excel Workbooks with SSRS 2008 R2

A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.  Read more...
By Stan Kulp 2011/08/22 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 5,729 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...
By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,898 reads

Excel in the Clouds

Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.  Read more...
By Steve Jones 2011/06/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

SQL Server Data Mining with Microsoft Office Excel

This article demonstrates using SQL Server's data mining capabilities with the Excel.  Read more...
By Additional Articles 2011/02/11 | Source: SQL Server Performance | Category: excel
Rating:  Rate this |   Briefcase | 5,461 reads

Protect the Excel files generated by SSIS package-Part I

It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed  Read more...
Rating: |  Discuss |   Briefcase | 6,187 reads

Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010

The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.  Read more...
By Additional Articles 2010/10/20 | Source: CODE Magazine | Category: odata
Rating: (not yet rated)  Rate this |   Briefcase | 1,872 reads

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 59,061 reads

SQL Server 2008,Windows 2008 x64 and Excel

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.  Read more...
Rating: |  Discuss |   Briefcase | 7,113 reads

How to Read Excel Cells from SQL Server Integration Services

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.  Read more...
Rating: |  Discuss |   Briefcase | 14,049 reads
<< Newer    Items 21 to 40 of 70    Older >>