ExcelBanter - PivotTableWizard using SQL Analysis Services

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - PivotTableWizard using SQL Analysis Services (https://www.excelbanter.com/excel-programming/365754-pivottablewizard-using-sql-analysis-services.html)

Kam

PivotTableWizard using SQL Analysis Services

I would like to use PivotTableWizard to construct a PivotTable in VFP using
SQL analysis Services.

..PivotTableWizard(SourceType, SourceData, TableDestination)

SourceType should be equal to xlExternal
TableDestination should be fine,
but

does anyone know how to construct the SourceData?

All times are GMT +1. The time now is 10:20 AM.