Importing text files to use as tables
After you create a table in system specifications, and add and format the necessary columns, you can use this procedure to import data into the table, instead of entering it using the table editor.
Table data can be imported from text files with Unicode or UTF-8 format. One line of text represents one row in a table, and text separated by semi-colons represents one column. : Do not place a semicolon after the text in the last column of a line. Leading and trailing spaces are removed from the values. 
Example:
Use this procedure
-
On the tab of the Administration module, expand and select .
-
Right-click the table and select .
-
Navigate to the text file you want to import and click . A message asks if the file is in Unicode format.
-
If the file is in the correct format, it is imported successfully. If not, an error message is displayed, stating the problem.