Email:      Pass:    Pass?
Advertisements


Free Excel Forum

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?




Similar Excel Video Tutorials

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
Create a 12 Month Calendar With The Current Day Highlighted in Excel
- Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a nicel

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 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 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 .




I have a Pivot Table created in Excel from a Query in Access, if I create the Pivot in Access the data shows as Y and No but when it is created in excel using the same Access query it shows as a Number (1). Does anyone have any idea how I can resolve this. I much prefer Excels Pivot features to Access. Many thanks


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!


I am trying to create a pivot table in Excel. I have the data being pulled from a query in access then the recordset is copied into Excel and the results are made into a pivot table. Unfortunately, the number of rows in the data query now exceeds Excel's limits. Can I make a ptable in Access and copy it to Excel through VBA code?

Thanks


Before the gory details, I am simply looking for a way to stop a user from refreshing a pivot...here's why....



We automate reports using a combination of Access and Excel with Access sort of running the show. We start by defining queries to build the table required for an Excel pivot. Next we run the queries to build the table. Next we create the Excel file (we call it a template) that points directly to the Access table. Finally we build a button in Access that invokes the queries, opens the Excel template, refreshes the pivots therein and writes the Excel file to a specified location. The user picks up the file from there once we have refreshed it for the month.

As users get more sophisticated (and I use that term loosely), I fear someday they will realize they can refresh a pivot. I do not want them doing tis for two reasons:

1) Many tables are large and I empty them in Access after the Excel sheet is written. If they hit refresh its bye bye data.

2) Some Access table are reused. Example: We create a report for each dept. We run dept 1, refresh the template for dept 1, write the report for dept 1. We then continue with dept 2, 3 4 etc etc. If the user hits refresh at an inopputune time, well they might get another dept's data.


So I want some security. I am not sure if I should be somehow securing the data base OR preferable if there is a simple way in Excel to simply prohibit the user from refreshing the pivot.


Thoughts, ideas....Thanks!


Hi,
I have a pivot table with a number of calculated fields. I want to create another table on a different tab that will still have access to the calculated fields. I need ready access to several perspectives without having to rearrange the same table constantly.

In the "old" excel world, whenever I created a new pivot table the wizard would ask if I wanted to use the same source data as an existing table to keep the file smaller. I would say yes, and then I had another table with all the fields. No need to recreate the formulas.

Now, in 2007, when I create another table, the wizard does not ask the question - it just creates a new table. The new table does not have the calculated fields in it.

How do you get a "new" table on another tab, or even on the same tab for that matter, with access to all the calculated fields?

Thanks much.


When I create a Pivot Table in Access (using the pivot table wizard under forms) I am unable to see what the "source" for my pivot table is. If I'm not diligent in naming my pivot table the same as the query or table it is based on, I have no way of telling where the data is coming from. I've looked in design view and at all the properties and still can't seem to find it. Any thoughts? Thank you. Marie


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 have used the Pivot Wizzard - Get External Data and create Multi Sheet/Tab pivot tables in the Past. Very familiar with this process. I do not see this functionality in the Excel 2007 "ribbon" (##?@@!!! - I don't like the ribbon).
I am under a tight deadline and have not used Access in a bunch of years. While I intend to migrate and leverage Access, I need an Excel solution if it exists. How do I create a Multi Tab Pivot Table in Excel 2007?


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.


This is really urgent, any advice please.

I'm trying to create a Pivot in Excel 2007 fed from an Access 2007 Database. When I try and Select the table (Insert Pivot), the queries aren't there?

There Query uses a lot of expressions so I've created an extra step to create a select query off this first query and link the Pivot to that but that query isn't there either?


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 to create a dynamic pivot chart whose title changes as the pivot table is changed.

I mention Excel Web Access in the title as some of the solutions I have read about include adding text boxes which are not acceptable on Excel Web Access and Sharepoint.

I know nothing of VBA, so I was hoping for an answer which does not involve using it.

Is that possible?