Export form PivotTable, then Import into PivotTable

R

Rycho

Hi there,
I'm connecting PivotTable to OLAP Cube on the server:
<script language="VBScript">
OLAPProvider = "Provider=................"
OLAPCube = "Sales"
Function start()
PivotTable.ConnectionString = OLAPProvider
PivotTable.DataMember = OLAPCube
End Function
</script>

then i'm building "my PivotTable" and here is a question:
how to export it to xml file whitch can be imported once again?
when i'll export it to Excel, it's building PivotTablexxxx.HTM file in
Temp, then Excel is reading this file, but how to import it into blank
PivotTable?
When i'm trying to import this file there is an error: Error opening
data file "file://c:\myfile.htm"
to import this file i'm using this script:
<script language="VBScript">
providerPivotTable = "provider=mspersist"
strdirname = "c:\myfile.htm"
Function start()
PivotTable.ConnectionString = providerPivotTable
PivotTable.CommandText = strdirname
End Function
</script>

What's wrong with this? Any ideas?
I have tried also to save this file from excel in .csv and .xml format,
but it's not working anyway.
Please help,
Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top