Defining dBASE-compatible files

You can define an ACL table from any file that conforms to the dBASE file format standard. The Data Definition Wizard parses the data in the dBASE-compatible file and uses this information to automatically define the ACL table layout. The dBASE file format is provided as a standard export option by many different databases and business applications, so it can be used to access data from a variety of data sources.

You can access dBASE-compatible files on your local computer or a network drive, or from a folder located on an ACL Server (if installed).

To create a table from a dBASE-compatible file:

  1. Select File > New > Table.

    The first page displayed in the Data Definition Wizard depends on your configuration. If integration with ACL Server is enabled the Select Platform for Data Source page is displayed, otherwise the Select Local Data Source page is displayed.

  2. Complete one of the following steps to select the location of the file:
    • If the Select Platform for Data Source page is displayed and you want to use ACL to define the file, select Local and click Next. In the Select Local Data Source page select Disk and click Next.

    • If the Select Platform for Data Source page is displayed and you want to use an ACL Server to define the file, select ACL Server and select the Windows server profile from the drop-down list, and then click Next. In the Select ACL Server Data Source page select Flat Files and click Next.

    • If the Select Local Data Source page is displayed select Disk and click Next.

  3. In the Select File to Define page, locate and select the file you want to create the ACL table from and click Open. dBASE-compatible files have a .dbf file extension.
  4. In the File Format page, verify that the dBASE compatible file option has been selected and click Next.
  5. In the Final page, verify the settings for the new ACL table and click Finish.
  6. Enter a name for the ACL table you are adding to your project and click OK.

Section contents



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback