SQL Server Training Video - Linked Servers - How to Query Microso ft Excel Named Ranges and Worksheets (SQL Server 2000)

SQL Server 2000 DBA Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)

This SQL Server 2000 DBA tutorial comes from the LearnItFirst IT Training Video Library.

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

More info about this video:

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.

---

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