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

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

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

---

• Source: http://www.learndts.com
• Category: SQL Server Videobooks
• Skill Level: 300 (Intermediate)
• Length: 16:30 (11.4MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: named region, named range, set of cells, named cells, excel data, excel spreadsheet, subset, data type