ExcelBanter - VBA Code to create PIVOT from access needed

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA Code to create PIVOT from access needed (https://www.excelbanter.com/excel-discussion-misc-queries/101427-vba-code-create-pivot-access-needed.html)

VBA Code to create PIVOT from access needed

I have a CSV file and I wish to create a Pivot out of this.I am
reading CSV to access and then wish to create a pivot from
access.I am converting it in to acces so that no of rows do not do not
become a limitation in excel .
Some body with any idea or VBA code to automate this through VBA ?

All times are GMT +1. The time now is 09:46 PM.