Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage 100 ver 2014 Power Pivot connection

Posted By KathyW over 9 years ago

Is it possible with 2014 and 64 bit ODBC to connect to Sage 100 tables for Excel Power Pivot?

Everything I try I get tables not accessible. I know this has been an issue on older releases but I was hoping with new releases it would work.

If it is possible can you tell me the steps and the connection string to use?

0 TomTarget over 9 years ago

Not familiar with Excel Power Pivot, but the usual problem I have getting data from Sage 100 tables is solved by using the Microsoft Query in Excel to connect instead of the data connection wizard.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KathyW over 9 years ago in reply to TomTarget

That gets me the 1st table however when I attempt to add another using the same connection the data is not available
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mdavis over 9 years ago in reply to KathyW

Try Sage Intelligence (SIR). The connectors will pull the data for you as well as work with Excel Power Pivot.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Sage 100 ver 2014 Power Pivot connection

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING