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 as a Data Source - How to Import Excel Spreadsheets and Workbooks Using the Import/Export Wizard

  • ·Skill level: 100 (Beginner)
  • ·Run Time: 12:35
  • ·Instructor: Scott Whigham

Description:

Most people on a Microsoft Windows network use Excel so being able to upload Excel data into SQL Server tables is vitally important. This video helps you understand a bit of the architecture of Excel and DTS by showing you how DTS views Excel. You'll see how to manage spreadsheets and load data into SQL tables. This video uses the Import\Export wizard to show you the most common data movement scenarios.

Highlights from this video:
  • Dealing with worksheet names such as Sheet1$, Sheet2$, and Sheet3$
  • Best practices for loading data
  • Options for loading data into SQL
  • Editing the auto-generated SQL
  • Using the Query Builder to build Jet-sql queries as a data source
  • How to change the auto-generated table names in SQL Server
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
Excel as a Data Source - How to Import Excel Spreadsheets and Workbooks Using the Import/Export Wizard
3 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.