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

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

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.

---

• Source: Transact SQL videos
• Category: Dynamic Data Source Queries - How to Write Distributed Data Queries Using Linked Servers and more
• Skill Level: 400 (Intermediate - Advanced)
• Length: 10:59 (7.32MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

---

Keywords Associated with this video: excel, jet, worksheet