I've set up a fair few Sage Line 50 ODBC/Excel links but this one has stumped me.
We have a Vista machine on which ODBC was fine until we recently upgraded it to Sage v17. There was no Sage ODBC driver when I tried to set up the ODBC connection.
I contacted Sage support and they showed be how to install it from an executable file in the Sage directory but, although the process seemed to execute OK, nothing appeared in the ODBC drivers.
I tried again while logged in as admin but same issue.
Any thoughts?
Cheers
Replies (6)
Please login or register to join the discussion.
Hijack
Sorry to hijack your thread, but am I right in thinking the ODBC Link means you can use excel to input data into Sage?
Sorry but no
Sorry to hijack your thread, but am I right in thinking the ODBC Link means you can use excel to input data into Sage?
No you can't unfortunately - unless you have a developer who can write you something using SDO, you are stuck with import. ODBC is a good way of getting data out of Sage and into Excel but is a bit less used than it was since the excel add-in was introduced.
Coming back to the OP's issue - is excel showing the the V16 or earlier driver? You might try using that instead of the one you just installed.
Try the ODBC Data Source Administrator
The only other thing I can think of is that you might need to do some more configuration if you have done a manual install - try running the ODBC Data Source Administrator (either from control panel or odbcad32.exe) and see if the driver is listed and what options you can set