Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Pivot Tables using a CSV file
How can I create a Pivot table using a external csv file without create a
Data source (ODBC)? I want to create a pivot table from a file with comma separated values where the first line has the fields of the collum. If anyone can help me I will apreciate a lot!!! thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Pivot Tables using a CSV file
Not sure you'd be able to do that, but you can open the .csv in Excel, whcih
will turn those commas into field delimiters and allow you to pivt once in Excel... "Felippe Domingos" wrote: How can I create a Pivot table using a external csv file without create a Data source (ODBC)? I want to create a pivot table from a file with comma separated values where the first line has the fields of the collum. If anyone can help me I will apreciate a lot!!! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing data in .csv file | Excel Discussion (Misc queries) | |||
Creating CSV Comma Delimited File | Excel Discussion (Misc queries) | |||
Help Please! - Creating Function Calculated Fields within Pivot Tables | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Loosing My Pivot Tables during SAVE AS | Excel Discussion (Misc queries) |