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?
MH - 25 Jul 2006 18:44 GMT
Do a crosstab query in Access, it's faster and you can output the results
into Excel once you've finished.
MH
>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?