I need to write a pass-through query from microsoft access to take data from oracle tables into tables stored in a database on an SQL server. I don't have the option of making a local table, so I need to really have two ODBC connections in use in one query. Is this possible???
