OLEDB Datasource for Excel Pivotable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We would like to avoid the use of ODBC when linking a datasource to a
pivottable.
It theer any way to use OLEDB instead of ODBC for pivot-tables?

Regards,

Sven Peeters
 
If you look at the excel VBA help on the CreatePivotTable method of the
PivotCache Object, there is a code sample that shows how to create a pivot
table using ADO and in the example it uses OLEDB.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding datasource in Excel worksheet 1
How to update datasources of a pivot table ? 1
Pivot tables not refreshing after data source update 1
How to build / refresh pivot table without ODBC?? 1
Retrieve data saved in pivot table 2
Pivot table drill down sort 0
Connect to OLEDB..? 3
How to modify the sql statement on a pivot table using VBA- XL2000 1

Back
Top