Hi
I want to create a pivot table based on the results of an OLE DB Query against our JD Edwards accounting system. At present the worksheet created by the query is more than 45k lines and the workbook with the source data and pivot table is more than 54Mb.
I really want to populate the pivot table cache without having to create the worksheet with source data first. Is there a way to achieve this using VBA? I'm using Excel 2003.
More generally, is there a good book which explains Office Data Connections and OLE DB functionality clearly? I have Excel 2008 Programming - Inside Out and Bill's VBA and Macros for MS Excel but these only touch on the subject. Any suggestiuons would be geratly appreciated.
Regards
QB
I want to create a pivot table based on the results of an OLE DB Query against our JD Edwards accounting system. At present the worksheet created by the query is more than 45k lines and the workbook with the source data and pivot table is more than 54Mb.
I really want to populate the pivot table cache without having to create the worksheet with source data first. Is there a way to achieve this using VBA? I'm using Excel 2003.
More generally, is there a good book which explains Office Data Connections and OLE DB functionality clearly? I have Excel 2008 Programming - Inside Out and Bill's VBA and Macros for MS Excel but these only touch on the subject. Any suggestiuons would be geratly appreciated.
Regards
QB