Executing Access user defined functions from Excel

[John B]

I have a query that calls a user defined function in Access.

e.g. GetCurrentBatchID (gets the current batch ID).
Query1
Select getcurrentbatchID(), items, destination FROM Tbl

I would like to create a pivot table from this query (Query1) in Excel but
Excel complains that the user defined function is not "defined".

JB

 

[Douglas J. Steele]

Try using Automation. See http://support.microsoft.com/?id=210111 for some
details.

Otherwise, it's not possible, since when you query the data from outside of
Access, you're strictly using Jet, which doesn't know anything about
user-defined functions.

 

[John B]

I see, thanks for the confirmation. I resorted to creating a batch vba code
to generate the tables from the queries to be used in Excel.

JB