Sage 100

Probably a long shot here but whilst trying to import Sage data tables into the Power Pivot table wizard i get the following error: 'Object reference not set to an instance of an object' Any thoughts?

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…