Creating Pivot Tables using a CSV file

  • Thread starter Felippe Domingos
  • Start date
F

Felippe Domingos

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
 
S

Sean Timmons

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

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

Adding data to MS Access from csv file 0
Excel does not accept text format! 0
Pivot Table Counting Text Data 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table 0
Excel CSV Files; Creating Of 3
Trying to create custom labels from an csv file + Need items numerically counted out 0
Formula to Look up values from a pivot table 1

Top