Data Transformation Services Video Tutorial - Excel as a Data Sou rce - How to Import Excel Spreadsheets and Workbooks Using the Import/Expo rt Wizard

SQL Server 2000 DTS Tutorial: Excel as a Data Source - How to Import Excel Spreadsheets and Workbooks Using the Import/Export Wizard

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

This video is part of LearnItFirst's SQL Server 2000 DTS training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free SharePoint training