Trouble importing query results into Excel 2007 from Access

[stuboyle]

I am trying to import the results of an Access 2007 query into Excel 2007 using the data connection feature from within Excel. The Access query is just a simple select query with the underlying table(s) being linked via an OBDC connection.

I have found that if the Access query contains a single linked table that I can successfully pull the results of the query across to Excel. However, if the query contains more than one linked table, the results will not come across. Has anyone experienced this?

 

[Norie]

So you are linking to Access from another data source and then trying to import data from that link to Excel.

Silly question, but can't you just import direct from the original data source?

 

[stuboyle]

So you are linking to Access from another data source and then trying to import data from that link to Excel.

Silly question, but can't you just import direct from the original data source?

The original data source tables are very large. So I'm using Access to subset the data, among other things.

Maybe I could try MS Query to see if that will work.

 

[Norie]

How are you 'subsetting' the data?

If you are just using queries and then trying to import those, perhaps if you made them make table queries you could import the tables.

 

[stuboyle]

How are you 'subsetting' the data?

If you are just using queries and then trying to import those, perhaps if you made them make table queries you could import the tables.

I'm comparing 2 tables. If the value in one field is Like "DN*" in one table Not Like "DN*" in the other table, then I'm output the results.

I wanted to avoid the extra step of going into the Access database to run the make table query, but yes, that would work.

Do you have an alternative?

 

[Norie]

The only other alternative I can think of at the moment would be to do it all in code.

Perhaps even connecting directly to the source database rather than going through Access.