Why can't you create a query on the Access server that produces the old and
new columns you want and then use the ODBC link to that?

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Milind Keer" wrote in message
...
Hey Charles

Thanks again for the prompt reply.

In my Access I am not downloading complete DB, What I am doing here is I
am
using ODBC (& data source) Connection to link the database.
By getting doing this I can see all the data but I can't really add new
fields to this table because this is just a view.

Now to get a local copy of Data i have already tried Make Table query but
after some time getiing error "To many records" :(
That is why I said I can't really copy data on my local copy?
And because of this I can't add new field and can't get that new field in
Pivot table....

Do you think is there any other way handling this issue??

I m thinking of using SQL client instead of MS Access, will that solve the
problem??

Please advise.

Thanks again!!
Milind Keer