VideoYou 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.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
Open the package that contains the tables for which you want to copy data from the database to the package.
To copy data from all of the tables in the package,
Select the Exclude Config Tables check box. This prevents any associated configuration tables from being added to the package.
On the Home tab, in the Process group, choose Get Database Data. This may take a while depending on the number of records.
To copy data from selected tables in the package,
In the Tables FastTab, select the tables that you want to copy data from. Tip: Use <Ctrl+click> to select more than one table.
On the Functions tab, choose Copy Database Data to Package Data.
Click Yes to continue. This may take a while depending on the number of records.
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 the Package Data action on the Table tab. Once the package data is set up the way you want, you can apply the package, which will update the database data.
© 2018 Microsoft and IndustryBuilt. All rights reserved.
JustFood 2018 (11.00.00.00) | February 2018