Access to excel

[John]

Hi

How can I open up the result of an access query into excel, from within
access?

Thanks

Regards

[Randy Harris]

Re: Access to excel

"John" <John@nospam.in fovis.co.uk> wrote in message
news:401864d7$0 $2429$cc9e4d1f@ news.dial.pipex .com...[color=blue]
> Hi
>
> How can I open up the result of an access query into excel, from within
> access?
>
> Thanks
>
> Regards[/color]

In A2K, select Tools->Office Links, then choose Excel.

HTH,
Randy

[John]

Re: Access to excel

Through code?

Regards


"Randy Harris" <randy@SpamFree .com> wrote in message
news:zDZRb.3473 7$P%1.27454241@ newssvr28.news. prodigy.com...[color=blue]
> "John" <John@nospam.in fovis.co.uk> wrote in message
> news:401864d7$0 $2429$cc9e4d1f@ news.dial.pipex .com...[color=green]
> > Hi
> >
> > How can I open up the result of an access query into excel, from within
> > access?
> >
> > Thanks
> >
> > Regards[/color]
>
> In A2K, select Tools->Office Links, then choose Excel.
>
> HTH,
> Randy
>
>[/color]

[Randy Harris]

Re: Access to excel

"John" <John@nospam.in fovis.co.uk> wrote in message
news:401868e9$0 $2438$cc9e4d1f@ news.dial.pipex .com...[color=blue]
> Through code?
>
> Regards[/color]

DoCmd.OutputTo ...