A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Keeping the Pivot View from Access in Excel



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2004, 02:22 AM
Ferd
external usenet poster
 
Posts: n/a
Default Keeping the Pivot View from Access in Excel

I using the Pivot view to arrange my data nicely in
Access. The database is quite large, about 7,500 rows
and about 10 columns. I want to keep this view exaclty
in Excel so then I can manipulate the data, which is much
easier for me. I've tried many different ways. One was
to use the export command but that only takes me to
construct another pivot table in Excel. When I try to
sort the data the same way in Access, Excel give me
counts of the data when I dropped the data in the data
field. This is not what I want.

I also tried to use the control A combination to copy the
pivot table in Access. Because of the large amount of
data, Access would froze on me. There must be an easy
way. Its like copying a spreadsheet from Access to
Excel. Any help would be greatly appreciated!

Aloha.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
access ...excel and infopath integration trey braid Using Forms 0 June 14th, 2004 11:28 PM
Using Excel sheet for an Access form Yannick Using Forms 1 June 8th, 2004 08:12 PM
Size of Excel file Access db exports to. Tasha General Discussion 2 June 5th, 2004 01:48 PM
Should I use Access or Excel? Kelsey New Users 8 June 3rd, 2004 12:19 AM
Export Pivot Table to Excel Sheet Suntisuk Using Forms 0 May 28th, 2004 08:56 PM


All times are GMT +1. The time now is 03:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.