Excel 2007 64 bit Sage 100 2013

Is it possible to import data directly into Excel 2007 via ODBC?  I realize there have been discussion on this in the past, but I don't know if there is a clear resolution. 

Even now, with the 64 bit ODBC driver installed, upon connecting, I get the MAS login screen.  After providing login credentials, I get the 'unable to retrieve list of tables from datasource' error. 

I do NOT want to use Microsoft query for this - ultimately, I would like to pull data in from MAS via ADODB connection in vba code behind.

Is there another method I might try to make this work properly.