Categories

Manipulating and Massaging Data in Excel

Today’s author: Chad Rothschiller, a program manager on the Excel team. Chad is going to discuss using formulas to 'clean up' data in Excel. Overview Excel is a great tool to use when you need to take data in one format, manipulate it into another format, and push the results along to another process, e.g. a database

Filed under: DTS/SSIS | On : 2007 Nov 12 | From: Microsoft Excel 2007 (nee Excel 12) |

Differences Between WSDL and XSD

Searching via ASP.NET AJAX and Web Services without UpdatePanel

Similar Posts

Tip/Trick: Guard Against SQL Injection Attacks

SQL Injection attacks are really nasty security vulnerabilities, and something all web developers (regardless of platform, technology or data layer) need

International Mailto URIs in IE7

Introduction New to IE7 is more reliable and standards-compliant support for international mailto URIs. This post will describe how users, application

Using Parameters In Dashboards

Today we have a guest post from Dan Parish, who is a program manager on the Excel Services team. Dan is going to explain a bit more on how to use Excel

SYSK 203: Mind That Label Length in SQL Reporting Services

Another possible (but unconfirmed) bug in SQL 2005 Reporting Services If you have a SSRS report parameter that is multi-value and of one of the labels

Most Popular

How To Group ListView Items with ListViewGroup VB2005

Publishing Reporting Services reports to MOSS

How to bind Generic Dictionary with dropdown list

Parse Comma Delimited TextFile with Visual Basic 2005 TextFieldParser

Using the Active Directory Membership Provider with Forms Authentication in MOSS 2007

Using a parameterized SSIS package as a data source for SQL Reporting Services