Executing queries stored in database in Excel

J

John B

Hi,

I have a database with a query like:

Select MonthJoined, GetUserName(UserID), Title, DoB
from UserTable

GetUserName is a user defined function that retrieves user name based on
UserID

I want to use this query in excel as data source
via pivot table --> Getdata --> MS Query

but MS Query could not execute GetUserName() function.

Is there any way around this?

I would prefer not to create another query in Excel - maintain all queries
in Access rather than Excel.

JB
 
Top