Appendix C - IMPORT command

 

IMPORT <FIXED | DELIMITED [[DELIMITER('x')] [QUOTE('y')]> <'FileName'> INTO <TableName> LAYOUT <FieldDefinition>

 

• For DELIMITED files, FieldDefintion is:  Field1[, Field2 ] .
• For FIXED length files, FieldDefinition is Field1 <DataType> [, Field2 <DataType>] .

 

Example

 

Import data into the table Customers Delimited file using field delimiter "," and the quote "'" from the file 'c:\Wham\Import\SampleData.csv' would be formatted as:

 

IMPORT DELIMITED DELIMITER(",") QUOTE("'") 'C:\WhamImport\SampleData.csv' INTO CUSTOMERS LAYOUT Name, Address, Phone, Contact, CustomerID