This video is from our "SQL Server 2000 DTS" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS

  • ·Skill level: 300 (Intermediate)
  • ·Run Time: 16:30
  • ·Instructor: Scott Whigham

Description:

This video could be subtitled, 'How to Import Very Complex Excel Spreadsheets into SQL Server the Easy Way' just for easier classification.

In this example, you'll learn how to deal with worksheets that have multiple data sets on them (multiple named ranges) so that you can load these into SQL Server. This is absolutely essential knowledge for anyone who works seriously with DTS! This video uses a complex Excel example and loads it into multiple SQL Server tables in one DTS package using the Import/Export wizard.

Highlights from this video:
  • Creating and managing named ranges in Microsoft Excel
  • Dealing with complex Excel spreadsheets and locating just one piece of data
  • Writing JOIN queries in Jet-SQL using the Query Builder
  • Best Practices for datatype mapping from Excel to SQL Server
  • Adding primary keys to the destination table
  • Writing ActiveX Script transformations using VBscript
  • Dealing with Sheet1$, Customers$, Orders$ and worksheets
and much more

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Chapter 2: Working with the Common Tasks in DTS
1 Transform Data Task - An Overview of the Screens/Tabs
2 Excel as a Data Source - How to Import Excel Spreadsheets and Workbooks Using the Import/Export Wizard
Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS
4 Part 1 - An Overview of the Send Mail Task and How it Works in DTS
5 Part 2 - Configure SQL Server to Use the Send Mail Task and Correctly Execute Scheduled Packages
6 Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task
7 Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task
8 Part 1 - A Basic Walkthrough of the Built-In Tasks
9 Part 2 - A Basic Walkthrough of the Built-In Tasks
10 Pt. 1 - An Introduction to the FTP Task (the File Transfer Protocol Task) and How to Download Files
11 Pt. 2 - Using the FTP Task in Your DTS Packages
12 Pt. 3 - Working with Variables as File Names and Assigning File Names at Runtime
13 Pt. 4 - Assigning File Names at Runtime Using VBScript and the ActiveX Scripting Task
14 Pt. 5 - Working With Multiple Files and Using a Table to Store Processing Info
15 Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000
16 Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000
17 Pt. 3 - Using Integration Services (SSIS) to Migrate Tables from Access to SQL Server 2005
18 Pt. 1 - An Introduction to Using the Multiphase Datapump
19 Pt. 2 - An Introduction to Using the Multiphase Datapump
20 Pt. 3 - Data Transformation Tasks and Advanced Techniques Using the Multiphase Datapump
21 Pt. 4 - Performance Tuning Your ActiveX Script Transformations Using the MPDP

NOTE: This video is part of our SQL Server 2000 DTS course.
This video is from Chapter 2: Working with the Common Tasks in DTS

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.