Create a pivot from CSV or access

T

Tewari

I have a CSV file and I wish to create a Pivot out of this.I am
converting it in to access and then planning 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?
 
M

MH

Do a crosstab query in Access, it's faster and you can output the results
into Excel once you've finished.

MH
 
Top