Creating a Transform Pivot Table with ADO

An Excel file that teaches how to perform Creating a Transform Pivot Table with ADO operation.

Excel Creating A Transform Pivot Table with Ado

Row, column and value fields are defined in SQL. The result is returned in crosstab format. The table is transferred directly to the Excel sheet. An alternative structure to classical pivots is offered.

Hope it is useful.