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

Access to excel

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <se***@aol.com> wrote in message
news:aa**************************@posting.google.c om...
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

Nov 12 '05 #2

P: n/a
"juffles" <se***@aol.com> wrote in message
news:aa**************************@posting.google.c om...
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


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
Nov 12 '05 #3

P: 1
Can you find the code for the button for me thanks...

Amie


"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
May 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.