Forum Discussion

jadams0304's avatar
jadams0304
Frequent Visitor
9 years ago

Connecting to a Plex Database from Power Pivot in MS Excel

Hello,   Connecting to Plex or even using the tables is completely new to me.  I'm a SQL novice, but pick up on things quickly.    I'm trying to connect Power Pivot in MS Excel to Plex like I hav...
Need Help
jadams0304's avatar
jadams0304
Frequent Visitor
9 years ago

Thanks for your reply Angelia.  I'm using the ODBC connection option.  I downloaded the ODBC driver from Plex our ERP provider.  I'm using their 64-bit driver, because I have 64-bit Windows and 64-bit MS Office.  Below are the pictures:

 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi jadams0304,

Please check your 64 version driver's path, if it is located in the %systemdrive%\Windows\SysWoW64 folder. Please it is, please put it in this path.

Best Regards,
Angelia