Creating Pivot Table from a DAO recordset
 

Hi,

I was wondering if you could create a pivot table using a dao record
set or setting the source data to a recordset

eg.

ssql = "SELECT * FROM [Table A]"

set rs = db.openrecordset(ssql)

wksPivot.PivotTableWizard SourceType:=xlDAORecordset,
SourceData:=rs.OpenRecordset

or sumething like that

Thanks

Fokrul