I'm working with an Excel 2003 workbook and an Access 2003 database and have encountered a small problem.
I am able to import data from an Access table to an Excel workbook with no problem. The trouble is that I want to use one of my Access queries to pull the information, but the query does not appear as an option.
Do I need to build a query in Excel to pull the data, or is there a specific reason that my querie does not show? Some of my queries do appear as options, but not all of them, which seems odd.
Thank you for your assistance.