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.

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.

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.

Hi,

Sorry to take so long getting back to you, but I work and have a long commut.

In 2007, Press Alt D P this will put you in the 2003 pivot table wizard.
choose the External Data Source option and proceed as described in my
previous email.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Sunny" wrote:

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.

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.

Shane and Roger,

Thanks you very much and it worked great. Although I have couple more
questions:

1. I notice file size is very big as my csv file. I assumes it imports data
and not link the data. Would that be possible to link it only.

2. Is there any way in pivot table to find unique count? Like I want total
sales amount along with total sales person involved in that sales. Total
sales can be grouped in Region/county and some other filter. If I use count
that shows # of sales in the group which is different from # of unique sales
person.

I really appreciate your help.

Thanks.
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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.