| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
| pivot table from recordset - very slow performance | Charts and Charting in Excel | |||
| "acessor flags" creating pivot table from recordset | Excel Programming | |||
| reusing a recordset for a pivot-table? | Excel Programming | |||
| reusing a recordset for a pivot-table | Excel Programming | |||
Linear Mode
