SELECT SQL Server and Foxpro

[rtatum]

Is it possible to Join a SQL Table and Foxpro Table in the same SELECT statement? Another guy here at work had said that he thought you could use OPENROWSET but I have had little luck trying or with finding documentation.

 

[agoeddeke]

Randal,

I don't see a reason why you couldn't use OPENROWSET with the Foxpro OLE DB provider to join Foxpro/SQL data:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_78z8.asp

Andy