Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS - view details
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:and much more
- 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
- Source: http://www.learnitfirst.com/Course/149/Video/540/Import-Excel-Named-Ranges-Using-DTS.aspx
- Course: http://www.learnitfirst.com/Course/149/SQL-Server-DTS.aspx
- Skill Level: 300 (Intermediate)
- Length: 16:30 (11.4MB)
- Full Details
To download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: named region, named range, set of cells, named cells, excel data, excel spreadsheet, subset, data type
This video comes from the SQL Server 2000 DTS online training course, SQL Server 2000 DTS. And be sure to check out even more MSSQL Server DTS training videos.
