473,320 Members | 1,879 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Nov 12 '05 #1
3 2392
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
"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
amie
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: mytfein | last post by:
Hi Everyone, Background: Another department intends to ftp a .txt file from the mainframe, for me to process. The objective is to write a vb script that would be scheduled to run daily to...
3
by: Mads Petersen | last post by:
I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....
0
by: Jack | last post by:
Windows 2K Pro Access/Excel 2003 Hi there, I have a large number of password protected Excel Workbooks. The files are protected by code that runs when the workbook opens. The code asks the...
12
by: D. Shane Fowlkes | last post by:
This most likely belongs in another forum but I thought I'd start here. I have a COM Object written in VB6. The DLL will access MS Excel and use it's Object Library to write a customized report...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
3
by: rlntemp-gng | last post by:
RE: Access 2003/Excel 2003 Problem: After I close the Access application completely, I go out to the Task Manager and there is an Excel.exe object still sitting out there. My Access...
0
NeoPa
by: NeoPa | last post by:
Many of us have noticed that there are some very useful functions available to you when using Excel, but these same functions are not available, as standard, in Access. A particular issue I had...
5
ADezii
by: ADezii | last post by:
Periodically, the same or similar question appears in our Access Forum: How can I use Excel Functions within Access? For this reason, I decided to make this Subject TheScripts Tip of the Week. In...
16
by: Phil Stanton | last post by:
I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.