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 56    Older >>
 

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,206 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,563 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,595 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,835 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,075 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,482 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 | 25,854 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,744 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,427 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,742 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,379 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,136 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,301 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,407 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,835 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,016 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,493 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,872 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,215 reads

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

Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.  Read more...
By Brian Knight 2009/02/10 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,852 reads
<< Newer    Items 21 to 40 of 56    Older >>