Re: How to set up ODBC for PowerPivot use?

["M. Lazarus" <mlazarus@xxxxxxxx>]

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