Create a pivot from CSV or access

's Computer Specifications

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?

's Computer Specifications

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

MH

"Tewari" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create Excel Pivot tables from MS Access	chris	Microsoft Access VBA Modules	1	4th Mar 2010 11:24 PM
How do I create a Pivot Chart in Access 2007	=?Utf-8?B?Z2lic19uZWls?=	Microsoft Access	0	29th May 2007 01:52 PM
Import CSV fle to access and create a pivot using VBA	Tewari	Microsoft Excel Misc	0	2nd Aug 2006 11:15 AM
Create Pivot from access database by VBA	ST	Microsoft Excel Misc	0	26th Jul 2006 04:31 AM
Can Access create Pivot Table Reports	=?Utf-8?B?RXZhZA==?=	Microsoft Access Reports	2	12th Mar 2006 03:36 AM