Specifying conversion options for Excel files in folder data sources

You use the Settings tab of the Import Parameters wizard to specify how QMF will convert the data of the Excel file into a table in the folder data source.

About this task

To specify conversion options in Settings for the Excel file:

Procedure

  1. Click the Settings tab of the Import Parameters wizard.
  2. In the First row number field, type the row number of the Excel sheet that you want to be the first row in the result set.
  3. In the First column number field, type the column number of the Excel sheet that you want to be the first column in the result set.
  4. To limit the number of rows in the result set, select the Row limit check box and type the number of rows.
  5. To limit the number of columns in the result set, select the Column limit check box and type the number of columns.
  6. If you want to turn the first row of the Excel document into the column names of the result set, select the First row contains column names check box.
  7. In the Preview pane, you can track how each selection changes the layout of the result set.