To load key-value pairs into a lookup table, select the table to be filled from the list of value tables and open the table by double-clicking on it. You will now see the properties of the lookup table in the right pane and can change them there if necessary. On the left you see the sections System and Standard with the two menu items Entries and Location queries. Click on Entries to open the Grid View of the key value pairs. Here, entries can now be maintained manually or entered from the clipboard via Paste Lookup Values. Preparatory you have ideally created a table in EXCEL¹⁾ with four columns of the following contents:

1. Foreign key²⁾
2. (optional) Foreign key description³⁾
3. lookup value⁴⁾
4. (optional) lookup value description⁵⁾

Select the cell range of all rows and the four columns and copy this selection to the clipboard with [Ctrl]+[c] and paste this into the table with the menu command Paste Lookup Values or keyboard shortcut [Ctrl]+[v]. Finish your entries by clicking on the button, so that the values are transferred to the eBiss database.

Note: Even if the second and fourth column must be filled only optionally, four columns must be selected, so that the import does not break.