ODBC text

[Brad]

i have created a program allowing me to execute queries
against text files using the microsoft text driver

i can also use the oracle odbc driver to connect an oracle
database and execute queries

I would like to run a query that joins an oracle db and a
text file. How can I do this?

ex

Select t.* from text_file t, oracle_db o
where t.name = o.name

[Russ Gray [MS]]

Hi Brad

You can't join tables from 2 different sources like that, you've got to
bring them to the same format so that you can use 1 driver. In your case, I
think that the best option would be to import the text file into Oracle.
Either that, or export the Oracle data to a text file.

Thanks,

Russ Gray
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.