Querying from different databases

[lancelitteken]

Is there any way to query different data fields from tables of various types of databases (ex. DB4, Oracle, etc.) all at the same time by using some sort of coding or other method with Visual FoxPro. If not, is there any other program capable of this. Any feedback would be appreciated. Thank you!

 

[TexCIS]

MS Access can link to many different kinds of tables at the same time. Go To . . . File, Get external data, link tables, and you can choose from .mdb, .dbf, .db, .xls, .csv, etc.

I used it once to link to FoxPro tables in a DOS accounting system to create reports that the old system couldn't generate.

Good Luck!

 

[bkj123]

I've used MS Access to link to Oracle and Teradata at the same time using ODBC. Warning: Performance was an issue.

Thanks.