Xero) and the ODBC driver that is required to connect to it (e.g. An ODBC data source stores the connection details for the target database (e.g. You will need this to create your data source.īefore you can use the Xero ODBC Driver to connect Excel to Xero, you need to configure an ODBC data source. You will need this to create your data source.
In the App details page for the newly created app, copy the Client id. In the OAuth 2,0 redirect URL box, enter:. Enter your organisation's web site URL in the Company or application URL box. In the OAuth 2.0 grant type section, choose Auth code Web app. In the Add a new app screen, enter a meaningful name in the App name box. Add a Xero Oauth application, by choosing New App. We recommend that you create a Xero app for each Xero ODBC data source that you create. 
Now, create a Xero app, which the Xero OAuth mechanism will use to authorise and keep track of your ODBC connection.
Install and license the Xero ODBC Driver on the machine where Excel is installed.įor installation instructions, see the Xero ODBC Driver documentation. Download the Windows Xero ODBC Driver. The Xero ODBC Driver is available to download from the Easysoft web site: The Xero ODBC Driver enables you to connect Microsoft Excel to Xero and work with Xero data in your spreadsheets.
0 kommentar(er)
