Returning Data From Access

[Mark]

I am trying to return a large chunk of data held in an Access database into
a worksheet using the copyfromrecordset method. The data is obtained from a
query within Access, the only problem is that the query in Access uses a
user defined function to help generate the result set. As a consequence
whenever i try to return the result set into a recordset from code within
Excel it comes up with an error 'undefined function'. Is there any way to
run the Access query from within Excel even though there is a user defined
function within that query.
TIA
Mark

 

[BrianB]

In the absence of another reply ...

I would either make the query a "Make Table" query and link Excel t
the table, or leave the function out and do the calculation in Excel