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