Hi Sunny

In Excel 2007Data tabGet External DataFrom Other Sourcefrom Microsoft
Query
It then proceeds the same as XL2003
Text filesOKChoose your CSV fileSelect fieldsReturn DataPivot Table
Report

--
Regards
Roger Govier

"Sunny" wrote in message
...
Sorry for not clear about my question.

I am using excel 2007 and I tried to follow your steps for excell 2003 but
there is no Get Data option. Can you please guide me for excel 2007? Would
that import data in excel or create link to csv? Do i have to do same
excercise every time I create new csv file?

Thanks for looking into it.

"Shane Devenshire" wrote in
message ...
Hi,

So what's your question?

If you're asking if it can be done, the answer is Yes.

If you're asking how to do it, the question is - what version of Excel
are
you using?

For Example in 2003 you would choose Data, Pivot Table and Pivot Chart
Report, and choose External data source, Next, Get Data, choose New Data
Source and click OK. Enter a name like myCSVData and open the second
dropdown. Select Microsoft Text Driver (*.txt,*.csv), click Connect.
Uncheck Use Current Directory, and then choose Select Directory. Find
your
file and open it, you will be in a wizard, whose steps are fairly
straight
forward.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Sunny" wrote:

I am dumping huge data to csv file, Now what I want to do is, create
pivot
table/chart from csv file without importing data into it. Reason behind
doing this is, end user view updated report without messing with thier
limited excel knowledge.