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
knoNOgeek@SPAMhotmail.com
"It's not IT, it's IS"
"green fox" <a.fox@sympatico.ca> wrote in message
news:1113959312.508364.23050@o13g2000cwo.googlegro ups.com...[color=blue]
>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
>[/color]
