tologo Importing from .xls

Top  Previous  Next

With TO3000, Version 9.0 Import Utility you can import data from your .xls files directly to TO3000, Version 9.0 database.

 

To link source and target fields:

1. Select the required target field from the Target Fields in TO3000 Database list.

2. Select the corresponding cell of .xls file in the preview area by clicking row or column caption using Ctrl key (the corresponding row or column will become blue highlighted).

3. Once both target and source fields have been selected, press Enter (the corresponding row or column will become green highlighted).

Alternatively, select target field, click Add button and specify which column to link.

After you select all the corresponding cells for the current table field, proceed to another field and repeat all these operations for each dataset field.

If you do not want some first rows or columns of the source table to be imported, set the number of such rows in the Skip title rows: and Skip title columns: edit fields.

 

Example:

Below the link was established between Name field in TO3000, Version 9.0 and column A of Microsoft Excel file.

import_utility_XLS