Importing query results from CSV and text files

You use the CSV File Import wizard to import CSV and text files to the data source.

1. Select File > Import.
   The Import wizard opens.
2. Select CSV File and click Next.
   The Import result set from file page of the Import wizard opens.
3. Click Browse next to the File name field.
   Select either CSV file (*.csv) or Text file (*.txt) in the Open window to choose a CSV or TXT file to import.
4. Specify what encoding to use when importing the file from the Encoding list.
5. Click Next.
   The Select separator options page opens.
6. Specify the separator options of the CSV or TXT file and click Next.
   The Result set structure page opens.
7. Specify column options of the result set in the Field definitions table and click Finish.
   Note: When you import a query result set from a CSV or TXT file, QMF scans the first 1000 rows of the result set to determine the maximum length of the VARCHAR data type. If the subsequent rows contain the VARCHAR data type that is longer than this maximum value, the cell value is truncated. You can increase the length of the data type in the Field definitions table.
   The CSV File Import wizard closes and the new result set opens in the editor window.