In Express

This one is also as easy as Studio Express. The prerequisites are the same as Studio: 

1. Select the Import data option from the File tab.
2. You need to write SQL to start importing the data.

ins into AP.countries (?,?)

1. ? here defines the number of columns in your file.
2. Turn off the import function and execute Sel * from the table name to verify the data:

To use the CSV file, select Options, as shown in the following screenshot:

Data transfer is a two-way street. We sometimes also have requirements to export the data to a file.

Teradata Studio Express and SQL Assistant both can be used to export data as well.