Importing File

Ribbon bar. Select the Home tab. In the File group, click Open to display the Open dialog box.

Classic menus. From the File menu, select Open to display the Open dialog box.

Select a text file (*.txt) and click the OK button to display the Importing file dialog box.

Import as Spreadsheet. If you want to import the text file as a spreadsheet, select this option button.

Delimited. A text file with separators between data elements, e.g., tab characters or commas.

Fixed. A text file which has a fixed size for number of characters in each line.

Import as Report. Click this button to import the text file to a report.

Set as default. Select this check box if you want the options selected in this dialog box to always be used as the default when a text file is imported.