Display Access union query results in excel

hi

i am trying to display the results of a union query in access...but when i try to link to the query from excel the union query is not selectable.

any ideas?

thanks

i have found a solution i thought i would share

In excel 2007 I was able to add a new ODBC connection (not the default MS Access one) and select the union query.

Then under the "get external data" option select "existing connections" and select the connection you just created.

You can also do in two mode:

one) you create a query in your access db and import it from excel as a table

two)
go in macro recording (choose menu tools, macro, record new macro),
now choose menu data, import external data, new query on db and select some fields from a table you have on db and complete data import
stop macro recording

go in your macro and change the query including your union query. It will work without problems.

Here an example of the recorded macro:

Please Login or Register  to view this content.

Regards,
Antonio

Thats a cool trick - thanks!

Hi ,

Will this logic(recording a macro) work for excel 2003??

thanks in advance