Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Excel Rss

Search for any content tagged excel

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

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 | 146 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,251 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 | 5,691 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,610 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 | 58,907 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,087 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 | 13,675 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,177 reads

Automating Excel from SQL Server

How to have SQL Server drive Excel spreadsheets  Read more...
By Wayne Sheffield 2010/02/19 (first published: 2008/12/05) | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 34,925 reads

Import Excel Spreadsheet to Database Tables

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...
By Peter He 2010/02/17 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 17,522 reads

Use SSIS to import one cell of an Excel file into SQL Server

Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.  Read more...
Rating:  Rate this |   Briefcase | 3,809 reads

Self-Service BI with PowerPivot for Excel 2010

Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.  Read more...
By Thiago Zavaschi 2010/01/22 | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 4,397 reads

Exporting to Excel Using a CLR Stored Procedure

The inclusion of the CLR in SQL Server has been controversial, but some people have come up with great ways to take advantage of this feature. New author Anders Pedersen brings us a technique to export data from SQL Server into Excel using the CLR.  Read more...
By Anders Pedersen 2009/12/02 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 18,246 reads

Database defintion from an Excel Spec?

Have you ever been required to create a database with nothing but a specification in Excel?  Read more...
By Ian Hadlington 2009/11/12 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 7,303 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,512 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 | 58,907 reads

Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2

I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.  Read more...
By Additional Articles 2009/07/22 | Source: MSSQLTips.com | Category: data mining
Rating: (not yet rated)  Rate this |   Briefcase | 2,070 reads

Tracking and Reporting Database Growth

An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.  Read more...
By Lokesh Gunjugnur 2009/06/02 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 12,623 reads

Installing & Congfiguring DM Add-in for Excel - SQL School Video

This SQL School video explains how to use the Data Mining add-in for Excel 2007. The installation and configuration are covered.  Read more...
By Brian Knight 2009/02/19 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,894 reads

Data Mining in Excel 2007 Pt.2 - SQL School Video

In this video MVP Brian Knight continues on with more advanced data mining using Excel.  Read more...
By Brian Knight 2009/02/12 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,238 reads
<< Newer    Items 21 to 40 of 57    Older >>