Hello,
I have a created a query in Access database and I can view the pivot form of that query by clicking "Pivot Table view" tab at the bottom right of the page.
My question is how to export this view to Excel spreadsheet. What command in VB should I use to do it. Is it at doable?
Thank in advance for helping,
Sarah
I have a created a query in Access database and I can view the pivot form of that query by clicking "Pivot Table view" tab at the bottom right of the page.
My question is how to export this view to Excel spreadsheet. What command in VB should I use to do it. Is it at doable?
Thank in advance for helping,
Sarah