use access linked table query as excel datasource
Posted on 2011-10-31
I'm trying to set up and access 2007 query as a data source for an excel 2007 table. The query in access is based upon a few linked tables, which link to oracle and sql server. The excel connection only returns the query headers and no data, but, running the query through access returns several records (query takes about 15 sec to execute).
There is no password required for the access database, but, there is for the linked tables, which are stored in access.
Any ideas on what's preventing the table data showing up?