Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Create A Pivot From Csv Or Access

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

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?



View Answers     

Similar Excel Tutorials

Make Your Macros Available in All Workbooks in Excel
In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook. To do this we need t ...
Loop through All Worksheets in Excel using VBA and Macros
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only take ...
Completely Hide the Quick Access Toolbar in Excel
I'll show you how to completely remove the entire Quick Access Toolbar from Excel. This will allow you to have a s ...
Use a Form to Enter Data into a Table in Excel
You can enter data into a table in Excel using a form; here I'll show you how to do that. This is a great feature ...

Helpful Excel Macros

Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel.
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when

Similar Topics







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 ?




I have a CSV file and I wish to cretae a pivot table out of this.
I have written a macro to import this csv to access and then another
macro to create pivot.

My problem is that I run first macro from access and second from excel.

Is it possible to create a VBA code which will ask me name of the
access databse , location of the CSV file and the name of the excel
work book and do the all three task by using above macros?

A code example will be a great help.

How can I rename or change the labels on my pivot using VBA so that
code goes in my second macro .




I have a CSV file and I wish to cretae a pivot table out of this.
I have written a macro to import this csv to access and then another
macro to create pivot.

My problem is that I run first macro from access and second from excel.

Is it possible to create a VBA code which will ask me name of the
access databse , location of the CSV file and the name of the excel
work book and do the all three task by using above macros?

A code example will be a great help.

How can I rename or change the labels on my pivot using VBA so that
code goes in my second macro .




Well, I tried looking but I did not see anyone else having this issue so maybe it's just me doing something wrong.

Well, I have a data warehouse that I export data from as .csv files. I then link these in an Access database and then link an Excel pivot table to the linked tables in Access. This has worked fine until our IT department decided to upgrade to Office 2007. The reason for performing this origami is because these reports can be up to 200,000 rows and the data warehouse cannot output in an Excel 2007 format.

Now, I don't see a way to link a pivot table to a linked table in Access at all and my existing reports fail to update properly (4 pivot tables linking to 4 linked tables in Access).

I did see that I could create a view query in Access for the linked tables and then I could link my pivot table to that and that appears to be reliable. Then my problem becomes that once I create a second pivot table to a second query, the first pivot table link breaks. I also had to create some fake static tables in Access so that I could even select a second query to link to so that should have been my first clue that I was going down a dead end.

I also asked this in the Access forum because I don't know which program is the cause of the issue.


Well, I tried looking but I did not see anyone else having this issue so maybe it's just me doing something wrong.

Well, I have a data warehouse that I export data from as .csv files. I then link these in an Access database and then link an Excel pivot table to the linked tables in Access. This has worked fine until our IT department decided to upgrade to Office 2007. The reason for performing this origami is because these reports can be up to 200,000 rows and the data warehouse cannot output in an Excel 2007 format.

Now, I don't see a way to link a pivot table to a linked table in Access at all and my existing reports fail to update properly (4 pivot tables linking to 4 linked tables in Access).

I did see that I could create a view query in Access for the linked tables and then I could link my pivot table to that and that appears to be reliable. Then my problem becomes that once I create a second pivot table to a second query, the first pivot table link breaks. I also had to create some fake static tables in Access so that I could even select a second query to link to so that should have been my first clue that I was going down a dead end.


Hi All,

I am a VBA novice and am planning what I need to do to solve a problem and would appreciate some help

I have a table of data approx 5000 rows long and 20 columns wide.

I need to group this data into categories and then convert the summary table into csv.

I am going to use vba and I thought I should:

1) create a pivot table
2) convert pivot table into csv

Do you think this is the best way to approach this problem?

I feel confident in creating the code for the pivot table but I haven't written code for converting a pivot table into csv format before.

Any suggestions would be appreciated.


I have multiple pivot tables in Excel XP using MS Access DB. The DB size is increasing regularly and it takes around an hour to refresh.
I was thinking to create OLAP cube for this Access query and use it as a base for my pivots.
When I choose External Data option from the Pivot menu, and then I click on the OLAP cubes, in the next dialog for New OLAP data source, I do not know how to proceed further from here i.e How to configure my MS Access DB query as OLAP source for my Pivot.


So here i am with another issue that has popped up with this dam project im working on. Here is the idea:

I have created queries in an access database that compare 2 sets of data, previous and current, and compares them using a function that i wrote in VBA (fComp()). Instead of writing a HUGE iif statement in access, i wrote this function to make it nice and clean. It works very well.

Now comes the second part of my project, Excel pivot tables. Because everyone that will be using the data found in the Access database wants pivot tables, i must give them pivot tables. So i create a spreadsheet for each comparison query that i have written in Access and start setting up a pivot table using the Access database as the datasource. As simple as that sounds, i get this error "Undefined function 'fComp' in expression." I know what it's telling me, but i dont know WHY it's telling me this. Since Access would be runnign the query to populate the data for the pivot table, i cannot understand why it's pooping out on me. Is there a way to pass that function from Access VBA to Excel VBA?

help.

Emanuele


Is it possible to create a pivot table directly from a csv file that is longer than Excel's row limit without Access. My csv contains almost 200,000 records so importing over several worksheets would defeat the purpose of avoiding Access. The pivot table feature obviously has the ability to handle records that exceeds Excel's ability to import thanks to MS Query. One would think that querying a csv file would be a piece of cake.

I can go to the pivot table wizard and choose external data and click Get Data. Why not have the ability to pull in a csv there along with dbf, Access and the rest? It has the option of "New Data Source" but I'm at a loss on how to proceed from there.

Any ideas?

Thanks!


Once I've created a pivot table in access, when I click the edit button, if excel is not already open, it will cause an error. So - two questions:

1. when I "automate" this for other users I need to check to see if they have excel open already, if not I need to open excel, then open the pivot table

2. since I'm not sure if multiple users can access the same pivot table - I want to force them to save the pivot table off as an export - but they will need to refresh. Is there a way to refresh the pivot table before it leaves access?

Thank you Marie


I created an Excel pivot chart against a large data source table within an Access file. I shared this with a coworker, who called me over with a question about which table within the Access file the Pivot table was referencing. I can't find that anywhere within the pivot table properties, or anywhere else in Access.

Is there a place to see what Access table an embedded Excel pivot table is pulling its data from?

Note that we are using Excel and Access 2000.


Hi,

I just installed Excel 2000 on my computer. I have a problem with the Pivot Table Toolbar. Every time I create a pivot table from any set of data, the pivot table separates itself from under my Standard Toolbar and appears in the middle of the screen. After I drag the fields into table in order to create the pivot table, I ALWAYS have to put back the pivot toolbar back into its place (under the standard toolbar). IN my Access 1997, I never had to do that. The Pivot toolbar always stayed in its place.

Is there anyway to have this toolbar be like it was in Access 1997, i.e. stay in its place instead of separating itself from other toolbars?

THANKS SO MUCH!


Hi,

We have an excel worksheet with a pivot table on data in one of the worksheets.

The data in the worksheet is 63K rows and the Pivot table references this. Now in 2009 we are adding extra rows to the range and it will exceed 65K rows. We have excel 2003 so that is a problem.

So the solution is to reference the pivot table externally. We have the file of data saved as a .dbf file.

I tried using Data --> Pivot Table and Pivot Chart Wizard --> External Data Source --> Get Data --> Browse

But the dbf does not show up.

Also I can import the dbf into access, so is there a way of doing a pivot table on a table in access? I can also export the access table into a csv if that format is more usable.

Thanks for your help.


I have designed a pivot table via the 'Forms' object in Access and want to export the results into Excel in the same format as the resulting pivot table in Access.

When I try to export in Access or import in Excel, the file that goes/comes across isn't in the same format as the pivot table in Access and I have to do further formatting in Excel to get the data back to the same format as the Access pivot table.

Is there a way of getting the result I need without further work in Excel or querying Access in Excel to pull the results across?


Thanks


I am converting from Excel to Access. Many of my Excel pivot tables data changes colors based on different ranges of the values. (conditional formatting). I am unable to get it to work using Access Pivot table view. I tried the conditional formatting but it just does not want to work.

Is this possible?

Mi


I need VBA code for -
To open a new excel workbook from access and then insert data or create
a pivot in excel sheet.
I want to pass the name of the file so that its created in excel as
..xls file and the pivot is created in that.

Thanks a lot in advance for your help




Hello All,

Recently I've built out various pivot tables (5 to be exact) with ODBC connection from an Access Query File in Excel 2003. 4 of the queries are the same just rearranged in differently in pivot format.

The issue I am having is that my pivot table is not reflecting the actual data. First the Pivot does not update with the most current list of names. (Approx about 190 names) When I open up the access file it does show the name exists, however that's not what's being reflected in the drop down boxes.

I've tried to refresh the data and removing the field and re-entering and no such luck.

Can anyone assist with idea's of what this issue could be?


I am exporting data from Access into Excel and then creating a pivot table to summarize. For some reason 6 of the 6336 summarized rows has an invlaid amount in the Grand Total cell for the row ( like 4.44089209850063E-16 when it should be 0).
I tried converting the amounts to currency on the Access side before exporting to Excel, but the six continued with non-zero amount in total cell.
I also searched Microsoft Excel to see if there was a 'fix' for this - but, no joy, possibly because I don't know the correct terms to search under.
I even tried exporting and creating the pivot table manually (normally everything is done via a module in the Access database). But even manualy, those 6 rows are wrong.
This problem is ruining my results. Solutions? Thoughts?


Hi,
I developed a dashboard in excel 2003 based on a pivot table linked to an access database. The Access database will be updated on a weekly basis.
I would like to create a listbox in my dashboard that contains only the pivot items of a pivot field. Can you help please?



I would like to built a Pivot which gets it's data from an MS Access
query which requires a parameter, which I would like to pass from
Excel.... is this possible?

if so, could someone please supply some sample code, the issue I am
having problems with is the parameter. I do not want to create the
pivot table or querytable using a SQL string from within Excel, I want
to use the Access Query.

Help or advise would be appreciated....fast [smile]

PWS


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



I'm using an Access table with around 220K lines to create a pivot table that should end up with around 15K rows and 16 columns total.

I have created pivot tables like this before, in fact I create one every month and haven't had any problems that I can't solve, but this one has me stumped.

It will retrieve the data, update the fields, and get about halfway through creating the pivot table. Then it just stops. All dialogue boxes go away, I don't get any warnings or errors, and no pivot table appears. I'm left with a worksheet that is as blank as a new one.

I'm at a bit of a loss. I recreated the source data file and put in only half the data and I get the same result. I can create small pivot tables from a 3x3 set of random data, but I'm lost without so much as an error message.

Could this be a memory problem? I'm trying to convince IT to get me set up with 2007 instead of Excel 2003.


Hi Folks:

I thought this would be a no brainer but since the record macro doesn't capture Pivot Table Wizard commands, I am at a bit of a deadlock.

I am trying to refresh a pivot table from an access database based on a combo box selection -

Here is the Scenario:

If the user changes the date field in the drop down box, eg: Sep10 to Oct10, then I want to refresh the Pivot table with the dataset Oct10 from the access table reports.

Assume the Access database is located at "C:\Access\Database and the Pivot table is PivotTable(1), I simply want to change the data that feeds the pivot table.

Can someone refer me to an example, or supply some code to re-source the data please?

Thanks very much in advance

Don McGimpsey




I have a massive 190MB 400k+ row access database
(i took the data into access from excel since performance and file size was resulting in excel frequently crashing).

I have to create several reports from this table.

I want to know what is the best way to create several pivotable reports from a single source but keep file size at a minimum?

As of now, I read the raw data in Excel via external source in access and then copy the same pivot across 15 tabs and modify it along?

I read about Powerpivots, but is that more for creating pivots from multiple data sources?

Suggestions welcome.

Hi there,
I am trying to create a calculated field in a pivot table, which I have created within an access query.

I have the following columns:

Main column "ERSP N" (A) contain 2 sub columns "PAX/CPN" (aa) and "PAX/CPN PY" (aaa)
Main column "ERSP Y" (B) contain 2 sub columns "PAX/CPN" (bb) and "PAX/CPN PY" (bbb)

Example calculation:
bb/sum(aa+bb) = %

If I export the pivot to excel I can do it manually, but I would like to be able to see that information in access.

Can anyone help please?


I have a pivot table with a bunch of sales data split into 3 worksheets (so 3 tables.) This file is 65 megs and takes about 2 minutes to open.

1. Is there a better way of doing this? Access database? On our intranet w/ a database background?
2. If I pick a customer on pivot table 1, worksheet 1, can vbscript choose the same customer on all on worksheets?
3. Any way to speed it up if I don't move to option 1 above?
4. Should I create the pivot tables and pull data from Access?

Thanks!