Question about Query with Foxpro Table

[jfield817]

I have an SS 6.5 database
I need to do queries on a table in the
database with a foxpro table not in the database.
Can the foxpro table be imported using a stored
procedure then joined with the sql server table ?

thanks
john

 

[foxdev]

If I understand correctly, you want to execute a single SELECT statement that joins both SQL Server data and a FoxPro table - yes?

Your idea of first importing the FoxPro table into SQLS would probably work, but would be quirky and time-consuming. If the tables involved on SQLS is not huge, you would be better off SELECTing the SQLS table into a local FP cursor, then using FP's SELECT to join that with your local data. Assuming we are talking Visual FoxPro, that is.

Not that it helps you much, but in SQLS 7/2000 you can perform a heterogenous join where SQLS will join both SQLS tables and tables from other data sources together in a single SELECT. Really cool, especially when it works (it is somewhat picky about the supported data sources, but DBF is one of the supported types).

 

[jfield817]

Robert,

Yes we are talking VFP .....The join process must
occur within the Sql-Server environment.
I understand that with SqlS 7.0 you can set up
linked servers to do the heterogeneous joins from
different sources ...
Is there a way to Sql Server to open foxpro
tables directly and join them with native Sql tables ?

thanks
john

 

[foxdev]

John (jfield817) asked:
Is there a way to Sql Server to open foxpro
tables directly and join them with native Sql tables ?

I believe it can be done in SQL Server 7 or 2000 using the OPENROWSET() function. I don't know of a way to do it in SQL Server 6.5.

 

[jfield817]

Thanks
John Field [sig][/sig]