Importing from Access Accounting Dimensions
Requirements
- Microsoft Windows SQL Server installed locally on the machine performing the import.
- The required Access Accounting file is filename.bak, obtained by launching Accounting Dimensions and performing a whole data back-up operation (see Accounting Dimensions online help).
Prerequisites
- If Protection is activated, you require the File right, Import, to perform this operation.
- Store a backup copy of your database using the Access Dimensions Administrator (ADA) tool supplied with the software package.
-
If the import is running on the same machine where the original Access Accounting Dimensions file is active, ensure that:
- The backup database file name is different from the active database name, and
- The database file is in a different directory than the active database.
Otherwise the original database must be removed from SQL server prior to importing.
Procedure
-
Open the client file in which you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
In the Import From field, select Access Accounting Dimensions and in the Version field, select the default version 2.41/2.43/2.50.
Note: Click here to see all accounting software supported versions.
-
In the Import Path field, type the exact path where the file you want to import resides or use Browse to locate the file manually.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
- Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Results
Accounting data is imported into the client file.