Multilpe Databases

I am trying to avoid access, so i want to connect to 2 databases.. one being an as400 and the other oracle. Any way to use the dsn connections for these 2 databases to pull fields from as400 table and the oracle table where they have the same txid?

I have found examples of doing this in access but I really want to keep access out of it.

Thanks in advance.

one for Oracle and one for AS400, and then
I think you should be able to get data from
both dbs separately.

Just a thought

Yes I have 2...but i want to combine the 2 in one select
statement :)