Excel macro to execute Access query
 

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

Excel macro to execute Access query
 

The best way to start is to record a macro while setting up the query manually.

From Worksheet menu
1) Tools - Macro - Record new macro
2) Data - Import External Data - New Database Query
3) Tools - Macro - Stop Recording.

"Denise" wrote:

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

Excel macro to execute Access query
 

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?

Excel macro to execute Access query
 

hi
if you have 2007 see this site
http://office.microsoft.com/en-us/he...491511033.aspx

regards
FSt1

"FSt1" wrote:

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?

Excel macro to execute Access query
 

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?

Excel macro to execute Access query
 

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?

Excel macro to execute Access query
 

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?