Re: How to set up ODBC for PowerPivot use?

Richard,

I'm somewhat limited to the client's request. Their Excel guru is setting up some analysis spreadsheets for them. PowerPivot gives him some additional features over the base pivot functionality. If someone has any insight as to the magic ODBC incantation to make this work...

-mark


At 12/26/2012 02:14 PM, you wrote:

I'm not a pivot expert, but what about dropping the data to an access database and then trying to use it for pivoting.

Could possibly be some limitations in the CA/400 ODBC DB driver.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

----------------------------------------------------------------------

message: 1
date: Wed, 26 Dec 2012 12:41:28 -0500
from: "M. Lazarus" <mlazarus@xxxxxxxx>
subject: Re: How to set up ODBC for PowerPivot use?

Jack,

When using ODBC, the file transfer is not needed. I have set up a Client Access ODBC connection, which works fine when doing a regular pivot table. When switching to Microsoft's Power Pivot Excel plug-in, even within the same sheet, it shows an error saying that the provider is missing.

-mark


At 12/26/2012 06:16 AM, you wrote:
>Maybe you can see if your missing this component.
>
>http://www-01.ibm.com/support/docview.wss?uid=nas1bb869681a60cf7ac86256
>8180060bbd4
>
>
>
>On Tue, Dec 25, 2012 at 5:15 PM, M. Lazarus <mlazarus@xxxxxxxx> wrote:
>
> > PowerPivot Excel add-in