Open topic with navigation
> ODBC / Using ODBC driver with Microsoft Office applications
Using ODBC driver with Microsoft Office applications
Accounts Professional only
Manually transferring data from one application to another can be time consuming and raises the possibility of mistakes. To help you transfer data quickly, easily and accurately, you can use the
Sage 50 Accounts ODBC driver to read your accounts software data directly from
applications such as
Word®, Excel®
and Access®.
ODBC is a software standard developed by Microsoft®and stands
for Open DataBase
Connectivity. An ODBC driver translates the data files from one application,
for example Sage 50 Accounts, so that they can be read by a Windows® application
that supports ODBC, such as Word®.
The ODBC driver is read only, so you cannot write back to
your software data files.
Although all ODBC compliant software should be able to
read Sage 50 Accounts data, the following applications have been tried
and tested by Sage and can all read Sage 50 Accounts data files.
- Open
Access®> File > New.
- Select Blank database > Create.
- File > Save Database As > browse to the required location > enter
a file name for the new database > Save.
- External
Data tab > ODBC Database > select Link to the data source by creating a linked table > OK.
- Machine Data Source tab > select the Sage 50 Accounts data
source, for example, SageLine50v20 > OK.
-
Sage 50 ODBC Connect login window >enter your Sage 50 Accounts password.
Tip: If your password is for the whole company - that is Access Rights is turned
off, then enter Manager in the User ID box and your password in the Password
box > OK.
- Link Tables window > select the table you require from this list, for example, SALES_LEDGER >
OK.
- Select Unique Record Identifier window > select a unique field, for example ACCOUNT_REF > OK.
You have now linked to your Sage 50 Accounts data from Access.
- Sage 50 Accounts > Help > About > Program Details area > note the data directory.
- Open Excel ®> open a new worksheet, or the worksheet that you want to connect to your Sage 50 Accounts data.
-
Data > Get External Data area > From Other Sources > From Microsoft Query.
- New Data Source > OK.
-
What name do you want to give your data source? > enter a name for the new data source, for example the company name.
-
Select a driver for the type of database you want to access > choose the required driver for your version, for example Sage Line 50 v20 > Connect.
-
User ID > enter your Sage 50 Accounts user name > Password > enter your Sage 50 Accounts password.
Tip: If your password is for the whole company - that is Access Rights is turned
off, then enter Manager in the User ID box and your password in the Password
box > OK.
-
Data path > enter the data directory for the company that you noted in step 1, including ACCDATA > OK > OK > OK.
-
Complete the Query Wizard to choose the required data for your query.
You have now linked to your Sage 50 Accounts data from Excel.
Tip: If you are using mail merge, you can quickly create a link to your word document from Sage 50 Accounts using File > Microsoft Integration > Contents to Microsoft Word > New Document.
- Open Word®
> Mailings tab > Start Mail Merge > choose the required document type.
- Select Recipients > Use Existing List > double-click +Connect to New Data Source.odc.
- Data Connection Wizard > select ODBC DSN > Next.
-
Select the Sage 50 Accounts data
source, for example, SageLine50v20 > Next > User ID > enter your Sage 50 Accounts user name > Password > enter your Sage 50 Accounts password > OK.
Tip: : If your password is for the whole company - that is Access Rights is turned
off, then enter Manager in the User ID box and your password in the Password
box > OK.
- Select the table containing the data you want, for example, SALES_LEDGER > Next.
- If required, enter a description for the data connection > Finish.
You have now linked to your Sage 50 Accounts data and can use the Insert Merge Field option to insert your Sage 50 Accounts data into your document.
For more information
How to link Microsoft Excel® to Sage 50 Accounts data
How to merge your Sage Accounts data with Microsoft Word®
To review Ask Sage, Business Advice and Health and Safety advice, go here. All contact details for Sage are available from here.
|
Go to top
|