# File Import to Table

Import a text file to a local table.

Action available for the following operating systems:

![](https://3821468174-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTlA1suFa5N48x_83N%2F-MAlPVpH3WRwBy16c7JY%2F-MAlQBZuuTnc6hyzKSVQ%2Fimage.png?alt=media\&token=5c9534b7-ca05-4ac4-b408-2207cd5a5295)

### Parameters

*General*

* **File** *\<string> -* The name of the file to import.
* **Table** *\<unquoted string> -* The name of the table to import the data.
* **Start of Record** *\<unquoted string> -* The string that identifies the start of the record in the text file. This parameter is coded.
* **End of Record** *\<unquoted string> -* The string that identifies the start of the record in the text file. This parameter is coded.
* **Field Separator** *\<unquoted string> -* The string separator for the elements between Start of Record and End of Record. This parameter is coded.

*Details*

* **Abort on Error** *\<unquoted string> -* Defines if the user wants to abort this action in case of error or not. The possible values of this parameter are: *Yes*, *No* or *dynamic*.
* **Trim Strings** *\<unquoted string> -* This parameter defines if the user wants to trim the strings or not. The possible values of this parameter are: *Yes*, *No* or *dynamic*. This parameter allows the user to remove spaces at rigth of the readed value from file, only when the column's type is String.

{% hint style="info" %}
For more information of this trim action please see the documentation about the function Trim.
{% endhint %}

* **Replace Duplicates** *\<unquoted string> -* This parameter defines if the user wants to replace the duplicate values or not. The possible values of this parameter are: *Yes*, *No* or *dynamic*.
* **Delete Source File** *\<unquoted string>* - This parameter defines if the user wants to delete the source file or not. The possible values of this parameter are: *Yes*, *No* or *dynamic*.

*Columns*

* **Column** *\<unquoted string> -* The name of the table column where the data is imported.
* **Type** *\<unquoted string> -* The type of the data to be imported. The possible values are:
  * String
  * Numeric
  * Date
  * Time
  * Date Time
  * Dynamic
* **Mask** *\<unquoted string> -* Defines if the user wants to apply a mask to the imported values.
* **Length** *\<numeric> -* Defines the length of the imported data.
* **Decimal Separator** *\<string> -* Defines a string separator that is used to separate the numeric values.
* **Decimal Part Length** *\<numeric> -* Defines the length of the numeric part.

*Default Values*

* **Column** *\<unquoted string> -* Name of the column that user wants to save a default value.
* **Value** *\<string>* or *\<numeric> -* The default value that the user wants to save.

{% hint style="info" %}
The actions File Open and File Close don't need to be used.
{% endhint %}