To open data files

  1. From the menus choose:

    File > Open > Data...

  2. In the Open Data dialog box, select the file that you want to open.
  3. Click Open.

Optionally, you can:

  • Automatically set the width of each string variable to the longest observed value for that variable using Minimize string widths based on observed values. This is particularly useful when reading code page data files in Unicode mode. See the topic General options for more information.
  • Read variable names from the first row of spreadsheet files.
  • Specify a range of cells to read from spreadsheet files.
  • Specify a worksheet within an Excel file to read (Excel 95 or later).

For information on reading data from databases, see Reading Database Files. For information on reading data from text data files, see Text Wizard. For information on reading IBM® Cognos® data, see Reading Cognos BI data.