Create a pivot from CSV or access

  • Thread starter Thread starter Tewari
  • Start date Start date
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?
 
Do a crosstab query in Access, it's faster and you can output the results
into Excel once you've finished.

MH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Code to create PIVOT in Excel from access database 1
Export Pivot table 1
Pivot Table Help! 1
pivot table loosing decimals (vba) 1
Excel VBA For excel 0
Access #Error & Excel Pivot 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Turning Data into a Table 1

Back
Top