Select the option to use Query Wizard to create/edit queries. In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query.You can then work with live Sage 50 UK data in Excel. Set the URL property to the value in the address field next to the company desired.A window is displayed containing a list of company names along with the address to their corresponding datasets. Click the Details button next to Sage 50 Accounts.If you have not already done so, open the Sage 50 UK software.These values will be the same usedĪdditionally, the URL property, under the Connection section, will need to be set to the address of the company dataset desired. The User and Password properties, under the Connection section, must be set to valid Sage 50 UK user credentials. Note: Only Sage 50 UK 2012 and above are supported. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). Follow the steps below to use Microsoft Query to import Sage 50 UK data into a spreadsheet and provide values to a parameterized query from cells in a spreadsheet. The CData ODBC driver for Sage 50 UK uses the standard ODBC interface to link Sage 50 UK data with applications like Microsoft Access and Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |