By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,221 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,221 IT Pros & Developers. It's quick & easy.

access query info to excel range

P: n/a
I need to take the results of a access query (quite small) and export
it into an excel worksheet-a range if possible. The worksheet is sort
of a way station where I need to execute a simple sum then send the
results to various cells in yet another worksheet. I fairly new at
this, so I'm scrambling. Should I use VBA or ADO? Or am I barking up
the wrong tree.

Andy

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Green fox,
Unless there is something that needs VBA I'd just go with the built in Get
External Data utility within Excel.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"green fox" <a.***@sympatico.ca> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
I need to take the results of a access query (quite small) and export
it into an excel worksheet-a range if possible. The worksheet is sort
of a way station where I need to execute a simple sum then send the
results to various cells in yet another worksheet. I fairly new at
this, so I'm scrambling. Should I use VBA or ADO? Or am I barking up
the wrong tree.

Andy

Nov 13 '05 #2

P: n/a
Thanks,

That's much better.

Andy

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.