We a variety of column update templates which you can create via AOI in order to extract and import data from the Access Accounting application.
However, you can't write all fields back, you can identify those that are updatable by the blue text either in the initial data or when you enter text.
To set up an update template:
Click Microsoft Excel then click the Access tab.
Click Templates then click Setup Update Template.
Select the relevant database then click Next.
Expand the relevant heading and select the required template.
Click Next.
Note: Column update templates have blue icons, other templates have yellow icons.Drag the first field and drop into the Column Fields box.
Click Set Range then select a column of cells.
Note: When selecting where to start producing the data, you must leave at least one cell free above a column to allow room for the field heading to display.Drag and drop any other fields necessary into the Column Fields box and click Next.
Click Next.
To enable certain data to be updatable in Access Accounting, select Enable changes to be written back to Access Accounts.
Note: Any amendable fields that can be written back into the software show in blue.To populate the template with data, click Insert.
To edit the template, click Edit.
To update data, click Update or select Complete Template.
Note: When the update is successful, the writing changes from blue to green. If unsuccessful, writing shows as red.To refresh the data in the template, click Refresh.