Importing into Lotus 1-2-3

To import the extracted data into Lotus® 1-2-3®, follow these steps:
  1. In 1-2-3, click the Import SmartIcon or choose File - New. 1-2-3 opens the File dialog box.
  2. Select a text type of Text - Delimited (*.TXT).
  3. Select the file to be opened. You might have to go to another folder or drive to find it.
  4. Click Open. 1-2-3 displays the Text File Options dialog box.
  5. Either click the option button start a new column at each Semicolon to indicate the character that separates the data fields, or type the separator character in the Other characters text box.
  6. Click OK. After a few seconds of processing, 1-2-3 imports the data into records in the worksheet.

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cpaug329.htm