Import Data File

You can import data from other applications and use the data as the source for your document. Use the Import Data File command to use data stored in Microsoft Excel, tab‑delimited, or comma-delimited file formats. The data is displayed in the Results section. You can then use the imported data to build reports and perform data analysis.

To import a data file:

Select File, then Import Data File, and then Data File.
The Import File dialog box is displayed.
Navigate to the location of the file to import.

Select a file type from the Files of Type drop-down list to make the file easier to find:

Tab delimited (*.txt)
Comma Delimited (*.csv)
Excel (*.xls) (the Import feature supports style and font information and Unicode strings [Excel 2000, Excel 2003 file formats]).
Note:
Interactive Reporting does not support the import of the Office 2007 format of Excel documents. As a workaround, save the document in an older Excel format and import the document again.

All Files (*.*)

Note:

If an Excel (.xls) file to be imported is not in table format, you receive the following error message: “Warning: Data you are trying to import is not in a tabular forma. Do you still want to import it? You can either reformat the data in Excel to a table format, or continue with the import. If you continue the format, the data does not map in the Interactive Reporting document.

Select the file to import and click OK.
The data from the imported file is displayed as a table in the Results section.
Select the encoding for the file from the Encoding drop-down.
The encoding parameter sets the output file encoding. It works for the file formats that allow you to use code page encoding like TXT, CSV and XLS. XLS supports a subset of encodings.