Thank this author by sharing:
By Andy Warren,
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
Please be aware you'll need to have the Adobe Flash 9 plug-in to watch this video.
Runtime: 2:06 minutes
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.