Set up a connection to text files

Specifies the settings for importing a database in text format.

In a text format database, data is stored in an unformatted ASCII file, where each record comprises a row. The data fields are divided by separators. Text in the data fields is divided by quotation marks.

Slóð á textaskrár

Enter the path to the text file or files. If you just want one text file, you can use any extension of the file name. If you enter a folder name, the text files in that folder must have the extension *.csv to be recognized as files of the text database.

Flakka

Click to open a file selection dialog.

Venjulegar texta skrár (*.txt)

Click to access txt files.

'kommu-aðskildar' skrár (*.csv)

Click to access csv files.

Sérsniðið

Click to access custom files. Enter the extension in the text box.

Aðgreinir gagnasviða

Enter or select the character that separates data fields in the text file.

Texta aðskiljari

Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator.

Tugabrotsskiltákn

Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5).

Þúsundaaðgreinir

Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000).

Leiðarvísir fyrir gagnagrunna