Powerpivot and Sage 50
I have tried to import data using Powerpivot from Sage 50 v18 (2012) but for some reason it just won't connect to the data using the ODBC datasource connection.
Can anyone help at all. The error message is User ID or Password invalid ": ERROR  User ID or Password invalid
ERROR  The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 18.1ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR  [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."
I can import via ODBC and MS Query normally using Excel data connection no problem but Powerpivot just doesn't work even though the ID and password used are exactly the same as importing via Excel. I have reinstalled the Sage ODBC driver to no avail.
Any help much appreciated. Thanks