Sage Accounting

Hi there Is it possible to set up an external query / database connection (ODBC/SQL/Web Query), so that I can automatically import & refresh my custom Excel reporting using my Sage Business Online Accounting data? I am currently exporting as csv…

Our business intelligence app in excel keeps repeating 'Sorry to tell you, but something has gone wrong in the app." We have tried various log ins and various pc's. This app is becoming more of a frustration than a tool.