Add data from file

Unlike “Update data from file”, this function adds data to a current set of records.



You can add data stored in database formats *.accdb, *.mdb, *.xlsx, *.xls, *.dbf, *.db, *.fdb.

  1. Click the right mouse button in the appropriate column
  2. Choose the menu item Add data from file



  1. Browse for the file


Note: Attributes Genus and Species are a numerical lookup therefore a data contains numbers


  1. Optional, if you choose an excel file, then appears window with lists of the file. Select a list



  1. Assign attributes of the source table to attributes of the target table
  2. Click OK



  1. Data is added to the database