Hi All

I have a ms access query which calls user defined function to generate the data. It works like a charm when i run the query in Ms Access; however, when i try to run the same query in Excel 2003 using Data -> Import External Data -> New Database Query I get the an error "Undefined function <FunctionName> in expression'.

Any information on this would be of great help.


Cheers
Arul

Sounds as though you're trying to use a user-defined function in your query. That's only possible if the query runs from within Access, not if it runs from any other client.

In Excel, go to "Tools" → "Macros" → "Visual Basic Editor". Copy and paste the function code for "fReminders" from Access (you'll find it in one of your modules). You now have the function defined in Excel

While that's true that that will put the function in Excel, you still won't be able to use it in a query.