Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Drop Down box or check box data to Excel Database | Excel Discussion (Misc queries) | |||
Excel Queries using Access data | Excel Discussion (Misc queries) | |||
Retrieving data from database (MS Sql Server) to Excel | Excel Discussion (Misc queries) | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) |