Access to excel

juffles

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

Subscribe Post Reply

2394

Alan Webb

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

Bradley

"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

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

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...

Microsoft Access / VBA

VBA code help Export Excel data to Access table

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....

Microsoft Access / VBA

Controlling Excel from Access: Using Sendkeys to enter data into an Excel Input Box

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...

Microsoft Access / VBA

Stumped - VB6 Com Obj can't access MS Excel

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...

ASP.NET

How will Access Survive

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...

Microsoft Access / VBA

Switching between Access and Excel using code

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...

Microsoft Access / VBA

Excel object still in memory after Access app runs

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...

Microsoft Access / VBA

Excel Functions in Access

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...

Microsoft Access / VBA

How to Use Excel Functions in Access

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...

Microsoft Access / VBA

Opening Excel from Access

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...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics