I tried VBA and it didn't work either. Some sort of Application Object error
(don't remember the exact error message). However, I managed to create a
pivot table in Excel by means of an ODBC connection. So I gave up trying to
figure out why it didn't work.
The following code created the Pivot ta
On Thu, 17 Nov 2005 13:36:27 +0100, Peter Sch?tz
<[EMAIL PROTECTED]> wrote:
>I am using Python 2.4.1 and I want to retrieve data from an Access database
>and display the results in an Excel pivot table. To get the data out of
>Access is no problem, but I have problems creating the pivot table in
Hi,
I am using Python 2.4.1 and I want to retrieve data from an Access database and display the results in an Excel pivot table. To get the data out of Access is no problem, but I have problems creating the pivot table in Excel. The following code is what I came up with (after running makepy on th