Executing queries stored in database in Excel
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
|