You could connect to the csv file, but the steps are different in Excel
2007 and earlier versions of Excel.

In Excel 2003, you could open a new workbook and choose DataPivotTable
and PivotChart report
Select External Data source, and click Next
Click Get Data
Select <New Data Source and click OK
Type a name for the data source, and select Microsoft text driver
Click Connect, select the directory, click OK
Select your table, click OK, click OK
In the Query Wizard, select your fields, and click Next 3 times, to get
to the end of the Wizard, click Finish
Click Next, click Layout, and set up the pivot table
Click OK, click Finish.

Holly wrote:
I have a 200K records csv file, I need to set up a pivot table to analyse the
data. How should I start?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html