Navigation:  Projetex Operations > Import > Importing Database >

Importing from .xls

Previous pageReturn to chapter overviewNext page

With Projetex Import Utility you can import data from your XLS files directly to Projetex database.

To link source and target fields:

1. Select the required target field from the Target Fields in Projetex Database list. This is the field in Projetex database where you wish to import data.

2. Click Add button.

3. Specify which column or which row to import data from, using Range Type settings. This is the field in source file from which the data must be imported.

Alternatively, select required source fields by holding Ctrl or Shift key, and using mouse to select required fields right in the table.

Create links for all the fields you wish to import.

If you do not want some first rows or columns of the source table to be imported, set a starting and finish row or column in Start and Finish settings correspondingly.

Example:

Below the link was established between Name field in Projetex and column A of Microsoft Excel file.

import_utility_XLS