LearnItFirst.com: Free Training Videos: Free Transact SQL Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Regions and Worksheets (SQL Server 2000)

LearnItFirst.com: Free Training Videos

Every time we post a new free training video on any site in the LearnItFirst.com Video Training Network, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Monday, April 17, 2006

Free Transact SQL Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Regions and Worksheets (SQL Server 2000)

Linked Servers - How to Query Microsoft Excel Named Regions and Worksheets (SQL Server 2000) - download

For those of you taking full advantage of Microsoft Excel's ability to expose "tables" to SQL Server, this videos helps you understand how you can query even the most advanced Excel spreadsheets and worksheets. No longer are you tied to querying the worksheet element; now you can query certain "tables" *called "named regions") in the worksheet and make your life much easier.

Category: SQL Server Videobooks
Skill Level: 400 (Intermediate - Advanced)
Length: 10:59 (7.32MB)
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