Data from Pivot table in Excel to Access

dhanushram dhanushram is offline

New Member

Join Date: Apr 2007

Posts: 1

28th Apr 2007

I have the following problem:
I have 3rd party research data which is in the Pivot table form. I want to export the data in the Pivot table to Access.

I tried double-clicking on the data which would give me a table. But that table contains only 65536 rows and I know that the source data should be more than 65536 records.

Any help?

Thanks

« Protecting whole workbook | Sorting chart by name »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot table in Excel. Exported data from access as excel sheet.	Angela	Microsoft Excel Programming	0	9th Jan 2010 01:59 PM
Exporting data to Excel pivot table from Access	Pat Dools	Microsoft Excel Misc	3	22nd Oct 2008 06:49 PM
Error msg-Using Excel pivot table to get data from Access table so	Dan24w	Microsoft Access Queries	0	4th Jun 2008 09:42 PM
Importing Data into an Excel Pivot Table via Access	=?Utf-8?B?QW5kcmV3?=	Microsoft Excel Misc	1	17th Nov 2004 10:40 PM
Refreshing Access data in an Excel pivot table	=?Utf-8?B?R3Vlc3Q=?=	Microsoft Access	0	15th Oct 2004 04:29 PM