Access to excel

Dear Anyone, I am a newbie so please forgive my ignorance. Is there
anyway that i can migrate data from access to excel and for the data
to be presented as a graph all in one single button?

Shankar

re: Access to excel

Juffles,
Look at Data:Import External Data option on the standard excel menu bar.
It's a built-in feature. You can either set up a dynamic link to the data
or import it as a static result. The only caveat may be that for an import
you may run out of rows at 65,536. Links can exceed the row limit of an
excel worksheet. Other than that, the rest is standard Excel stuff.

"juffles" <seet6@aol.com> wrote in message
news:aadd4a26.0403070642.11a82165@posting.google.c om...[color=blue]
> Dear Anyone, I am a newbie so please forgive my ignorance. Is there
> anyway that i can migrate data from access to excel and for the data
> to be presented as a graph all in one single button?
>
> Shankar[/color]

re: Access to excel

"juffles" <seet6@aol.com> wrote in message
news:aadd4a26.0403070642.11a82165@posting.google.c om...[color=blue]
> Dear Anyone, I am a newbie so please forgive my ignorance. Is there
> anyway that i can migrate data from access to excel and for the data
> to be presented as a graph all in one single button?
>
> Shankar[/color]

Depends...

You can certainly export data to excel.

You could create a chart on an Access form and cut-and-paste it to Excel. (I
use a button to do this and can probably find the code for you if needed.
I've also written code to export a series of charts to PowerPoint as a
slideshow).

Else you could automate Excel from Access (but that's probably getting a
little advanced few a "newbie" :)

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

re: Access to excel

Can you find the code for the button for me thanks...

Amie