AX2622

Populating tables with data

The following features are available to populate tables with data.

  • Import utilities
    You can import data from a source file or a database into an Axiom Software table. This method is typically used to import historical data into data tables.

  • Open Table in Spreadsheet
    You can open a table in a spreadsheet, and add rows of data to the table. This method is typically used to populate reference tables, although imports can be used for this purpose as well.

  • Save-to-database processes defined in Axiom files (Save Type 1)
    You can save data to a table from an Axiom file, such as a plan file or a report. This method is typically used to save planning data to data tables, or to perform data utilities such as allocations.

  • Copy Table Data
    Using this utility, you can copy data from any data or reference table to another data or reference table.

The following exceptions and limitations apply:

  • Picklist tables can also be populated using the picklist editor in the Web Client Table Manager.
  • Tables using the Large Table index scheme can only be populated using import utilities or Copy Table Data.
  • Document reference tables can only be populated by saving data from their source Axiom files, using Save Type 3.
See also