Re: TRANSFORM statements in ADO (Excel)
- From: Rob Wills <RobWills@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 02:52:04 -0700
Thanks cpnet
Unfortunatly I wanted the sum of the values to divide each other which Pivot
tables did not appear to support.
My code was correct and does actually work. The only issue was - I was
importing the data into the sheet and then trying to run the ADO without
saving the sheet first. (which I forgot)
Thanks again for your help.
"cpnet" wrote:
> TRANSFORM is something that is specific to Access. I think ADO MD might
> allow you to do some pivot table-like stuff, but that's not .NET, that's
> just regular Win32.
>
> However, you say your source data is in Excel, and the result should be an
> Excel Pivot table, so I'd just stick with Excel. Without knowing your whole
> spreadsheet setup, I think you can probably do what you want by creating a
> calculated field:
>
> = Ave / Amt
>
> If you add this calculated field to your Pivot Table as a Data Field, then
> Excel will actually treat it as "Sum(Ave)/Sum(Amt)"
>
>
>
.
- References:
- TRANSFORM statements in ADO (Excel)
- From: Rob Wills
- Re: TRANSFORM statements in ADO (Excel)
- From: cpnet
- TRANSFORM statements in ADO (Excel)
- Prev by Date: Re: DataTable.Select method bug in .Net Framework 1.1 SP1
- Next by Date: SQL CLR: which assembly to reference for microsoft.sqlserver.serv
- Previous by thread: Re: TRANSFORM statements in ADO (Excel)
- Next by thread: DataTable.Select method bug in .Net Framework 1.1 SP1
- Index(es):
Relevant Pages
|
