Powerpivot and Sage 50

Hi

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 [28000] User ID or Password invalid

ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 18.1ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [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 

Comments
There are 7 comments. Login or register to view them.

Try this

paulwakefield1 |

Except I meant to add......

paulwakefield1 |

This may help

paulwakefield1 |

Thanks Paul

jamieyoung |

There may be a better way and

paulwakefield1 |

Sage and Excel

barrysnashall |

Paul - That's great and did

jamieyoung |