Using MS Query in Excel to import a query with a function or with a subquery

[Dugantrain]

I am trying to use MS Query to import queries from an Access database. All of the queries import fine except:
-One query uses 2 functions in a module to capture the beginning and ending dates in a form. The query works in Access, but when I attempt to import using MS Query, I get the error "Undefined function 'f_Beg_Date'(which is the name of my first function) in expression"
-Also, I have a query which uses 4 different subqueries to perform aggregates (Select Count(My_Field) WHERE blah, blah....) and when using MS Query to get it into Excel, I get the "Expected Parameter" error. Note that this isn't a parameter query.

Are either of these errors avoidable based on my needs or is MS Query just not robust enough and I need to start delving into Automation?

 

[Ziggy1]

It sounds like a lot of work, but are you not just trying to put the query data into an Excel Spreadsheet? You can do this several ways:

Tools/Office links/ analyze with Excel
File/Export
Macro
VBA



Ziggy

 

[Dugantrain]

Well, yes and no. The query data IS going into an Excel Spreadsheet, but I'd like to set it up from the Excel side using MS Query so that any users who need a copy of the workbook may have it on their workstation and only need to Refresh. Also, the worksheets are heavily formatted, so MS Query would be a good temporary fix until I can take a breather from my current projects and starting getting into the world of automation.