SageForum for UK versions of Sage 50- Help and support.

Is it possible to write a data query in excel / ms query to connect to sage 50 v19? I can see that there is an ODBC driver available when in excel, but it doesn't connect to the data and I also am unable to create a new user dsn as the odbc driver is not available. We have to update 60 companies manually each month and it is very time consuming. A macro or some form of automation would be very helpful.

Thanks
Greg

It can be done with a VBA macro

You may have several issues, as regardless of anything else, you should be able to connect to data, the drivers should be there and you should be able to connect.

You need a 32bit version of Office, the latest version doesn't work with some of the older versions of Sage.

You need to look for/configure the 32bit ODBC drivers not the 64 bit drivers.