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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.