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.