To
import a text file to a database
Open the Data Transfer Tool.
Select Import Text File from the main console or the Transfer menu. The Welcome to Import from Text File Wizard window will open, displaying a summary of the steps to be taken in the wizard.

Click Next. The Choose a Source Text File window will open.

Enter the full path of a text file to import or click the browse button to search for a text file.

After you have selected a text file, click Next, the Text File Format Setting 1 window will open.

Open the text file in a text editor to check the format of the data.
Select the appropriate settings for the format of the text file you are importing.
Click Next, the Text File Format Setting 2 window will open.

Finish selecting the appropriate settings for the format of the text file you are importing. Click Next.
If you selected Fixed field from the Text File Format Setting 1 window, the Specify Column Length window will open. If you selected Column Delimiter, then proceed to step 12.

Click the horizontal line where you want to indicate the beginning of a column. A vertical line will appear, marking the column break. Use the scroll bar at the bottom to advance to other columns. Click Next.

The Choose Destination Data Source window will open.

Select the database to import data to from the Database menu.
Enter a user name and password into the appropriate fields.

Note: A user must have INSERT privilege to import a text file.
Click Next. The Transfer Setting window will open.

Enter a new table name into the Table Name field, or select a table from the menu. Selecting a table from the menu will allow you to choose to replace the destination table, delete rows in the destination table, or append new rows to the destination table. Click Execute to import the text file. A confirmation dialog box will appear.

Click OK
Related topic: