If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Jamie Collins wrote:
You can most definitely *execute* a Jet (MS Access) stored procedure (stored Query) using MS Query in Excel without VBA code. OK. Thanks for the clarification. I must give it a whirl. Pity my clients are all 2002 at latest....but one day... Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#12
|
|||
|
|||
Bill Manville wrote in message
Pity my clients are all 2002 at latest Why? You can *create* the procedure within MS Access using the PROCEDURE syntax e.g. I just tested your example PROCEDURE MyProc [argSiteID] INTEGER; SELECT * FROM Sites WHERE Sites=argSiteID in Access95 and it works fine and will work for all subsequent versions of MS Access. You can *call* the procedure within MS Query using ODBC's call syntax. Again, tested fine in Excel95 and above. Jamie. -- |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Merging with an Access 2002 parameter query | Trevor | Running & Setting Up Queries | 4 | August 31st, 2004 01:25 PM |
parameter query from data access page | Alice Dawson | New Users | 0 | August 12th, 2004 12:37 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |