Sage Excel Link Error
 

Hi

I am using ODBC to get data from Sage into excel. I have managed to
get this to work fine on my machine and I have the VBA code working to
automate the task. However when i try to do the same on my colleagues
machine (from scratch) it doesn't work.

I am on Excel 2000 and sage v11 (single co licence) whilst he is on
Excel 2000 & Sage v10 (5 company licence)

The error message which appears when i do DataGet External Dataetc
in excel is this ...

Cannot find all files in data path
Driver's SQLSetConnectAttr failed
The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER:2.00

There is one other posting relating to this but it is not that helpful
saying only "Yes thats a problem with the ODBC DSN".

Can anyone advise what I need to do on my colleagues machine to get
this working?

Thanks in advance.