Here's the link to the issue that I have faced.

http://support.microsoft.com/kb/319998

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"FSt1" wrote in message
...
hi
i've been using MSQ since xl97 and have had no such issues.

regards
FSt1

"Ronald R. Dodge, Jr." wrote:

I have attempted to use MS Query in the past with XL97, XL2000, and
XL2002
only to run into Excel crashing on account that MS Query uses ADO, and
within Excel, there is a documented issue with memory leaks when using
ADO.
I don't know if this issue has been fixed in XL2007 or not, but it is
documented for prior versions.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"FSt1" wrote in message
...
hi,
technically this built into xl via microsoft query.
2003 on the menu bar....datainport external datanew database query
set access db as the data source.
scroll to your access db.
when the table source apears, scroll down to the query and pull all of
the
queries fields into MSQ then just follow the rest of the wizzard.

regards
FSt1

"Denise" wrote:

Can I execute an Access query from an Excel Macro and bring back the
data
into the spreadsheet?