[FAQ000009]Is there a way to import CSV or text files?

Q

Is there a way to import CSV or text files?

A

There is a function to import a data file in CSV format into any table from the table management screen.

There are certain CSV formats that can be imported, so once you select the target table from the table management screen

and specify "Export table data" from the context menu to output a CSV file, add data to the file

(or create a file with an equivalent header), and then import it.

Import table data（CSV）

Also, if you want to create an application that imports CSV files, you can do so in the following two ways.

①Use the "Register CSV file data to table" action to import

Use the "Register CSV file data to table" action on the Data Operations tab to register the contents of the CSV file to the table .

The contents of the CSV file will be directly registered to the specified table.

② Set the data in the CSV file to the sheet and then import the CSV file

Use the action "Set CSV file data" on the File Operations tab to import the CSV file content and expand it on the sheet once.

Then, use the "Register data in table" action to register the data on the sheet into the table.

Add, update, delete data in table

The method in the above ① registers data in bulk, which allows for faster processing.

In addition, if you want to change the contents of the CSV file and register it, you need to use the method described in ②.