ODBC Access Driver, Custom Access Function and Excel

[kiwibaldman]

I want to use excel to retrieve the results of a query in Microsoft Access that utilises a custom function (in Access) to determine the amount of week days in the database. The error message I receive is: [Microsoft][ODBC Microsoft Access Driver] Undefined function Work_Days in expression.

I'd rather use a combination of Access and Excel for this report than base it all in access. Any ideas how to fix ?

 

[Cagliostro]

I believe you should save your query in Access and try to access it like you access a table. If you pass to access an SQL which contains a VB function from Access Application, ODBC will not recognize it.

Ion Filipski