Video

You can copy database data to a configuration package without having to export data to and reimport from Excel. Once you've copied data to the package, you can delete or edit data from the Config. Package Card. When copying data to a package, the data is also validated.

To copy database data to a configuration package

  1. In the Search box, enter configuration packages, and then choose Configuration Packages.

  2. Open the package that contains the tables for which you want to copy data from the database to the package.

  3. To copy data from all of the tables in the package,

    1. Select the Exclude Config Tables check box. This prevents any associated configuration tables from being added to the package.

    2. On the Home tab, in the Process group, choose Get Database Data. This may take a while depending on the number of records.

  4. To copy data from selected tables in the package,

    1. In the Tables FastTab, select the tables that you want to copy data from. Tip: Use <Ctrl+click> to select more than one table.

    2. Choose Functions>Copy Database Data to Package Data.

    3. Click Yes to continue. This may take a while depending on the number of records.

    5. The data is validated as it is copied. In the Tables FastTab, the No. of Package Records field will show the number of records that were successfully copied, and the No. of Package Errors field will show if any errors occurred with the copied data.

    You can edit or delete data from Table>Package Data. Once the package data is set up the way you want, you can apply the package, which will update the database data

See Also

Tip