I am trying to make a data connection to a query in an access database, which I do all the time. However, for this query, it's using 2 tables that are linked to separate databases (sql server and oracle). The query works fine, but, the data connection from excel only returns the headers and no records.
any ideas? (access and excel are both 2007)