473,722 Members | 2,266 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

trying to copy an Access 2003 pivot table to excel or word .... or something

Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.

I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!

Prining to a pdf works nice, but then I have headaches trying to
manipulate that format.

The only thing that I can get to work is to highlight and individualy
copy the rows, columns, and data area and paste into excel.
There has to be a better way

Thanks
Jerry
Dec 26 '05 #1
8 4866
On Mon, 26 Dec 2005 15:11:52 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

Try this when you have run the query:
tools > office links > analyze with Excel

-Tom.

Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.

I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!

Prining to a pdf works nice, but then I have headaches trying to
manipulate that format.

The only thing that I can get to work is to highlight and individualy
copy the rows, columns, and data area and paste into excel.
There has to be a better way

Thanks
Jerry


Dec 26 '05 #2
Thats what I've been doing, Tom - but I don't get the pivot table.
I get a spreadsheet with ALL the raw (database) data, and its too many
tows for excel to handle
Jerry
On Mon, 26 Dec 2005 09:52:15 -0700, Tom van Stiphout
<no************ *@cox.net> wrote:
On Mon, 26 Dec 2005 15:11:52 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

Try this when you have run the query:
tools > office links > analyze with Excel

-Tom.

Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.

I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!

Prining to a pdf works nice, but then I have headaches trying to
manipulate that format.

The only thing that I can get to work is to highlight and individualy
copy the rows, columns, and data area and paste into excel.
There has to be a better way

Thanks
Jerry

Dec 26 '05 #3
On Mon, 26 Dec 2005 17:27:29 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

I don't understand. Access can only create queries that output at most
255 columns (I may be off by 1 or 2). Excel can accept 255 cols *
65000 rows. If your query fits those maximums, there should be no
reason you couldn't output to Excel.
Perhaps you have left out a step or two in your description, or I am
too dense to see it...

-Tom.
Thats what I've been doing, Tom - but I don't get the pivot table.
I get a spreadsheet with ALL the raw (database) data, and its too many
tows for excel to handle
Jerry
On Mon, 26 Dec 2005 09:52:15 -0700, Tom van Stiphout
<no*********** **@cox.net> wrote:
On Mon, 26 Dec 2005 15:11:52 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

Try this when you have run the query:
tools > office links > analyze with Excel

-Tom.

Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.

I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!

Prining to a pdf works nice, but then I have headaches trying to
manipulate that format.

The only thing that I can get to work is to highlight and individualy
copy the rows, columns, and data area and paste into excel.
There has to be a better way

Thanks
Jerry


Dec 27 '05 #4
Tom

I am mystified too

I Access 97 this functionality worked fine..I could export just the
pivot table (I used it all the time).

The pivots I have are small (10 rows by 4-7 columns)

With Access 2003, when I am in PT view and export, or publish it with
excel, or analyze with with excel, I get an error message that says
I'm trying to export too many rows and that it has exceed the 65000
row limit..please go back and limit what you're tryig to export

Jerry


On Mon, 26 Dec 2005 22:05:26 -0700, Tom van Stiphout
<no************ *@cox.net> wrote:
On Mon, 26 Dec 2005 17:27:29 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

I don't understand. Access can only create queries that output at most
255 columns (I may be off by 1 or 2). Excel can accept 255 cols *
65000 rows. If your query fits those maximums, there should be no
reason you couldn't output to Excel.
Perhaps you have left out a step or two in your description, or I am
too dense to see it...

-Tom.
Thats what I've been doing, Tom - but I don't get the pivot table.
I get a spreadsheet with ALL the raw (database) data, and its too many
tows for excel to handle
Jerry
On Mon, 26 Dec 2005 09:52:15 -0700, Tom van Stiphout
<no********** ***@cox.net> wrote:
On Mon, 26 Dec 2005 15:11:52 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

Try this when you have run the query:
tools > office links > analyze with Excel

-Tom.
Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.

I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!

Prining to a pdf works nice, but then I have headaches trying to
manipulat e that format.

The only thing that I can get to work is to highlight and individualy
copy the rows, columns, and data area and paste into excel.
There has to be a better way

Thanks
Jerry

Dec 27 '05 #5
On Tue, 27 Dec 2005 12:33:16 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

You could turn your query into a make-table query, and export from it.
-Tom.

Tom

I am mystified too

I Access 97 this functionality worked fine..I could export just the
pivot table (I used it all the time).

The pivots I have are small (10 rows by 4-7 columns)

With Access 2003, when I am in PT view and export, or publish it with
excel, or analyze with with excel, I get an error message that says
I'm trying to export too many rows and that it has exceed the 65000
row limit..please go back and limit what you're tryig to export

Jerry


On Mon, 26 Dec 2005 22:05:26 -0700, Tom van Stiphout
<no*********** **@cox.net> wrote:
On Mon, 26 Dec 2005 17:27:29 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

I don't understand. Access can only create queries that output at most
255 columns (I may be off by 1 or 2). Excel can accept 255 cols *
65000 rows. If your query fits those maximums, there should be no
reason you couldn't output to Excel.
Perhaps you have left out a step or two in your description, or I am
too dense to see it...

-Tom.
Thats what I've been doing, Tom - but I don't get the pivot table.
I get a spreadsheet with ALL the raw (database) data, and its too many
tows for excel to handle
Jerry
On Mon, 26 Dec 2005 09:52:15 -0700, Tom van Stiphout
<no********* ****@cox.net> wrote:

On Mon, 26 Dec 2005 15:11:52 GMT, Jerome Ranch <ra*****@mchsi. com>
wrote:

Try this when you have run the query:
tools > office links > analyze with Excel

-Tom.
>Okay
>So I've got pivot tables setup in Access 2003.
>Only about 30K records in the current 2005 databases...the pivots
>summariz e the info in a number of nice ways.
>
>I need to get the pivot tables into a document so I can distribute the
>tables, as is, as an electronic report (without the detailed data)
>So I export to rtf and xls, and I get an error that there is a too
>much information. I don't want all the data, just the summary table!
>
>Prining to a pdf works nice, but then I have headaches trying to
>manipula te that format.
>
>The only thing that I can get to work is to highlight and individualy
>copy the rows, columns, and data area and paste into excel.
>
>
>There has to be a better way
>
>Thanks
>Jerry


Dec 27 '05 #6
Tom van Stiphout <no************ *@cox.net> wrote in
news:2a******** *************** *********@4ax.c om:
You could turn your query into a make-table query, and export from
it.


Would a plain old Ctrl-A, Ctrl-C, switch to Excel and Ctrl-V not
work?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 27 '05 #7
Duh
I thought I tried that and it didn't work
so I tried it again
and this time, it worked..several times (just to be sure)
but any nice formatting one might have done goes bye bye

I'm ashamed to post the result
duh duh duh

this functionality needs to be reworked
also, my functionality needs a serious upgrade as well

Thanks
Jerry

On Tue, 27 Dec 2005 14:25:50 -0600, "David W. Fenton"
<XX*******@dfen ton.com.invalid > wrote:
Tom van Stiphout <no************ *@cox.net> wrote in
news:2a******* *************** **********@4ax. com:
You could turn your query into a make-table query, and export from
it.


Would a plain old Ctrl-A, Ctrl-C, switch to Excel and Ctrl-V not
work?

Dec 27 '05 #8
Jerome Ranch <ra*****@mchsi. com> wrote in
news:f9******** *************** *********@4ax.c om:
On Tue, 27 Dec 2005 14:25:50 -0600, "David W. Fenton"
<XX*******@dfe nton.com.invali d> wrote:
Tom van Stiphout <no************ *@cox.net> wrote in
news:2a****** *************** ***********@4ax .com:
You could turn your query into a make-table query, and export
from it.


Would a plain old Ctrl-A, Ctrl-C, switch to Excel and Ctrl-V not
work?


Duh
I thought I tried that and it didn't work
so I tried it again
and this time, it worked..several times (just to be sure)
but any nice formatting one might have done goes bye bye

I'm ashamed to post the result
duh duh duh

this functionality needs to be reworked
also, my functionality needs a serious upgrade as well


I call this the "is-it-plugged-in?" scenario.

I once wasted 2 hours at a client's, trying to set up a DSL router,
and couldn't get it to work. When I finally got around to checking,
I realized the network cable was simply not firmly seated in the
jack.

So, I always make a point of going through these kinds of elementary
yet still fundamental troubleshooting tasks as a matter of course.
But I try to be gentle about it, since I'm as prone to making this
kind of error as anyone else.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 28 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2857
by: Alan Lane | last post by:
Hello world: I'm including both code and examples of query output. I appologize if that makes this message longer than it should be. Anyway, I need to change the query below into a pivot table query. I'm having trouble doing it. Help! Here is my code so far: Sub OldRegionQuery()
1
3403
by: rummey | last post by:
Hello, I am working in Access 2003. I have a pivot table that looks very good, and if I press CTRL+A, CTRL+C while in the PivotTable View then it will be copied into memory. I can then do CTRL+P in Excel and it pastes over great. Is there a way to do this with OLE Automation (or some other way)? I have been able to copy a PivotTable View of a Form to Excel with the following code:
1
4204
by: matthew kramer | last post by:
Hi, I'm using the reverse pivot technique on an excel spreadsheet to create a list dataset from which I can make a pivot table in excell. The only problem is that because there are so many years going across, whenever I try to do this the computer tells me it was only able to do an incomplete list because the full list exceeds 65,000 lines. Apart from having to break the dataset down into smaller datasets, is there some way that I...
0
1887
by: Alexander Mandl | last post by:
Hello I have a pivot table in an Access form and open the pivot Table (Excel OLE Object) from within Access. In the Excel Table is a macro (signed) (in teh open event) running when opening the excel object from within Access. Since my customer have installed O2K SP3 - the Makro does not run any longer. The curiosity is: If you open the Excel Object from within Access and then store it to a local file - then reopen this file - the same...
3
2397
by: Decreenisi | last post by:
Hi, I have to convert an existing spreadsheet for rejects into an access database. My problem is I use a load of lookup tabels in excel. How do I approch this in access. Also, just a general question, can you do pivot tables in access. Thanks
1
6829
by: christianlott1 | last post by:
I want to copy an Access pivot table into word with vba. I'm guessing I'd need to Select All, copy to the clipboard, and paste special into word at a bookmark. I know how to address the bookmark, I just don't know how to select, copy and paste (actually, I will probably be able to find the paste special command for word) via vba. Right now I have:
15
5352
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel 2003 application (Reports) works ok. But when Office 2003 is upgraded to Office 2007 Excel reports stops working. It Log the error “Exception from HRESULT: 0x800A03EC.” In database.
1
2631
benchpolo
by: benchpolo | last post by:
I have data extracted from Access db to Excel with a pivot table. Somehow, I am having issues with the pivot table were it doesnt update the totals. For example, the first extract i did in Access has 6000 data rows and pivot table in excel should refresh on open and reflect the 6000 data rows. 2nd extract in Access has 10000 data rows when pivot table opens it doesn't refresh the summary count on the pivot table based on the 10000 data...
2
4038
by: Marisol2 | last post by:
I have some queries in Access 2003 db that I have setup to display as pivots. I can go into design pivot table view and click on and then click on Export to Office MicroSoft Excel. The problem is I have about 6 queries that produce 48 reports (based on parameters). I don't want to manually save each pivot query results. The first macro I created to export the queries I used TransferSpreadsheet but the export results are regular xls...
0
8860
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
8739
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9382
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9236
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9154
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8043
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6681
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5995
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3207
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.