473,327 Members | 2,012 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,327 software developers and data experts.

Gather information from Excel PivotCache

Hi,

I'm currently working with a Legacy System whose only output is pivot
tables in Excel.

If I need certain data, I change the pivot table to get the information
I want. All the info is stored in the PivotCache as normally info would
exceed 65535 lines, so theres no detail in DB format.

I'd like to know if it's possible to connect Access to the pivotCache
of the Excel file, to gather information through queries.

Regards.

LC

Nov 13 '05 #1
1 3883
On 11 Jul 2005 10:21:19 -0700, ca******@yahoo.com wrote:
Hi,

I'm currently working with a Legacy System whose only output is pivot
tables in Excel.

If I need certain data, I change the pivot table to get the information
I want. All the info is stored in the PivotCache as normally info would
exceed 65535 lines, so theres no detail in DB format.

I'd like to know if it's possible to connect Access to the pivotCache
of the Excel file, to gather information through queries.

Regards.

LC

Hi
Should be possible via automation (ugh!)
See
http://msdn.microsoft.com/library/de...PivotCache.asp
Incidentally I see that that page has a HTML error on it.
My own knowledge of the subject is zilch so maybe this won't do what
you need but it seems to have a fairly full object hierarchy.

A tip: I found this by using Google looking for "excel pivotcache"
where it came up as the second item found.

David

Nov 13 '05 #2

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

Similar topics

14
by: Klaus Neuner | last post by:
Hello, I need to gather information that is contained in various files. Like so: file1: ===================== foo : 1 2 bar : 2 4
0
by: dim | last post by:
hi need little help: i'm querying access 03 tbls using ADO from excel and loading recordset into pivotcache...query built dynamically in vba (excel).. rs.Open szSQL, , , , adCmdText when...
2
by: Joseph | last post by:
Has anyone had any experience gathering the local computername through a web application with no client side program. I've been researching different avenues and have been coming up blank so far. ...
1
by: ABC | last post by:
How to gather the caller page information? I want to check the enter from when entering the onload event of the page. Which properties or functions have that information?
3
by: krazyjoe | last post by:
I have a Fluke 45 series multimeter. I would like to gather data from it through MS Excel and VBA. I have no trouble sending commands to the multimeter but I cannot figure out how to read data from...
2
by: LittlePhil via AccessMonster.com | last post by:
Someone please help before i start to cry. I'm trying to export from Access to Excel, then create a new excel sheet with a pivot table to display the data held in columns A:P. I get the error...
1
by: Vishakh | last post by:
Hello, I am trying to create pivot tables using data from CSV files. Here is an example: String conStr = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\\"; String query = "SELECT * FROM...
3
by: oli insight | last post by:
I have an excel spreadsheet with 500 rows of information. I want to copy and paste that information into an access table that i'm using, column by column.... But access only lets me copy and paste...
2
by: Gary Dunne | last post by:
Hi All, I'm struggling to find the correct syntax for creating a Pivot table in an excel file via VB . Net 2005 The Excel help file is not particularly helpful where parameters are concerned...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
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.