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.

--