Posted to microsoft.public.excel.programming

Chace

external usenet poster

Posts: 1

How to use ADO to change Pivottable sourcedata query

I can connect to my external database fine via ADO ODBC connection. However,
how do I change the sourcedata query for a pivottable in Excel via ADO code?
I do not want to use the MSQuery (i.e use the wizard) to do this because I am
running into sql string length limitations. This should be simple but I have
researched all day and cannot find the answer. Can you help?

Thanks,
Chace

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change pivottable datasource	zoeloe	Excel Discussion (Misc queries)	1	June 21st 05 07:36 PM
PivotTableWizard SourceData question	Microsoft Forum	Excel Programming	3	February 26th 05 05:50 PM
SourceData in pivot table	JIM.H.[_2_]	Excel Programming	0	June 9th 04 12:59 AM
Change SourceData in Excel PivotTable via VBA	CarlsonClan	Excel Programming	1	April 9th 04 04:15 AM
Setting up a SourceData:= in VB	Emmanuel[_2_]	Excel Programming	1	January 22nd 04 08:15 PM

All times are GMT +1. The time now is 04:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us