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 41 to 60 of 68    Older >>
 

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,760 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 | 4,218 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,433 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,634 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,308 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,841 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,057 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,304 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 Datamate Technology 2009/06/02 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 12,933 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,975 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,325 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 | 5,120 reads

How To Retrieve Excel Schema Information Using SQL Server Integration Services (SSIS) 2005

How can we determine the sheet names in our SSIS package and process this variable number of sheets?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,301 reads

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.  Read more...
By Additional Articles 2009/01/09 | Source: SearchSQLServer | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 2,638 reads

Use Excel to DIFF Your Query Outputs

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.  Read more...
By David Ziffer 2008/12/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,322 reads

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.  Read more...
By Additional Articles 2008/12/19 | Source: Database Journal | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 2,103 reads

Script to build a SQL Server Data Dictionary and report with Microsoft Excel

There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?  Read more...
By Additional Articles 2008/12/09 | Source: MSSQLTips.com | Category: excel
Rating:  Rate this |   Briefcase | 4,803 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 | 35,402 reads

FAQ: SQL Server Reporting Services

Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,869 reads

Calculate the Running Total for the last five Transactions

Calculate the Running Total for the last five Transactions on an Iterative basis  Read more...
By Divya Agrawal 2008/11/27 | Source: SQLServerCentral.com | Category: iterative
Rating: |  Discuss |   Briefcase | 4,383 reads
<< Newer    Items 41 to 60 of 68    Older >>