I have used Sage 200 ODBC links into Excel quite happily, but I now have to branch beyond that because of the type of queries I need - which are beyond Excel.
I am using MS Access, and need to run a 'pass through' query as the tables are too complex to link into Access.
To enable the pass through query to work, I need an ODBC connect string - but I cannot quite work out what that would be.
It is something along the lines of
ODBC; DRIVER=SQLServer;SERVER=DATA\xxx Database=yyy
This is relatively new to me, and I am lost on the syntax.
If anyone has any ideas that would be great - although I accept this is a bit niche.
We do have a support contract, but I am fairly sure the providers would ideally want us to pay for this kind of thing.
Enjoy the Royal Wedding peeps,!