| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEDB Datasource for Excel Pivotable
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
OLEDB Datasource for Excel Pivotable
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. -- Regards, Tom Ogilvy "Sven Peeters" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connection to Excel from .Net using Oledb | Excel Programming | |||
| Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
| OLEDB Help Excel 2002 | Excel Programming | |||
| EXCEL AND OLEDB | Excel Programming | |||
| Excel schema using Jet OLEDB Provider? | Excel Programming | |||
Hybrid Mode
