Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Pull Access Query into Excel (2003): Reposting
Hello: i previously posted code that successfully pulls an Access 2003 table
into an Excel 2003 spreadsheet. How is this done pulling a query, using a query name? (Not using a SQL string that defines the query.) Thanks~ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Pull Access Query into Excel (2003): Reposting
Bettergains wrote:
Hello: i previously posted code that successfully pulls an Access 2003 table into an Excel 2003 spreadsheet. How is this done pulling a query, using a query name? (Not using a SQL string that defines the query.) If it is a VIEW type query SELECT MyCol1, MyCol2 FROM MyQuery; If it a PROCEDURE type query: EXECUTE MyQuery arg1, arg2 or {CALL MyQuery arg1, arg2} Jamie. -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Pull Access Query into Excel (2003): Reposting
Hi Bettergains
A couple more suggestions if your using ADO. you didn't really give much information. I use the following: ' When using a connection object cnn.Open Set Rs = cnn.Execute("Your Query Name", , adCmdStoredProc) ' When using a Command object cnn.Open CMD.ActiveConnection = cnn CMD.CommandText = "[Your Query Name]" CMD.CommandType = adCmdUnknown Set Rs = CMD.Execute Good Luck TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 query from Access 2000 database | Excel Worksheet Functions | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
Applying Criteria in Excel Cell to MS Query Pull from Access | Excel Discussion (Misc queries) | |||
MS Query - from Access 2003 to Excel 97 | Excel Discussion (Misc queries) | |||
Reposting lost query about virus scan | Excel Discussion (Misc queries) |