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.