Connecting Tech Pros Worldwide Help | Site Map

Access to excel

juffles
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Alan Webb
Guest
 
Posts: n/a
#2: Nov 12 '05

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]


Bradley
Guest
 
Posts: n/a
#3: Nov 12 '05

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


Newbie
 
Join Date: May 2006
Posts: 1
#4: May 18 '06

re: Access to excel


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

Amie


Quote:

Originally Posted by Bradley

"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

Closed Thread