Can we connect Pivot to multiple source data (MS Access)
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
|