.png)
Importing a Delimited Text File
Perform the following steps to use the Text Import Wizard to import a delimited text file:
1 From the Query menu, point to Import/Export, and then click Import From Text File. The following window displays:
Note: You can also invoke the Text Import Wizard by opening Windows Explorer, navigating to and selecting the text file you wish to import, and then dragging it to the WinSQL Catalog window.
2 Click New.
3 Click Browse.
4 Navigate to the location containing the text file you wish to import, select the file, and then click Open.
5 Click Open.
6 Click Next.
7 Ensure the Delimited format is selected:
.png)
8 Click Next. The following window displays:
.png)
9 Choose the appropriate delimiter that separates the text in your file.
10 If your file contains field names or column headings, click to select the First Row Contains Field Names check box.
11 Once all options have been selected, click Next. The following window displays:
.png)
12 Select In a new table if you wish to import the data into a new table in your database. If this option is selected, you must type a name for the new table in the blank field.
OR
Select In an existing table if you wish to import the data into an existing table in your database. If this option is selected, you will be prompted to select the table in which you wish to import the data.
13 Click Next. A window similar to the following displayed:
.png)
This window displays a CREATE TABLE statement that defines the design of the new table, allowing you to make modifications, if desired.
Note: You may make changes to the field types or lengths, but do not modify the table name.
14 If all field types and lengths are correct, click Next. The following window displays:
.png)
15 Click Finish.
Note: If you wish to save this import as a template, either browse to or select an existing template file, and then click Finish.
The data is imported, and a message similar to the following displays:
.png)