Creating Fortune1000 Export File in ASCII format

Procedure

Exporting the Fortune1000 file

While in the Fortune1000 client file, from the main menu choose Utilities.
Choose Export to Lotus 1-2-3.
Select the items you want to export to Lotus 1-2-3.
Enter the export file name. Fortune automatically assigns a file name extension of .prn and places the export file in the current client directory.

Note: Lotus 1-2-3 can also be used to save the export file in an ASCII text file format.

Saving the file in an ASCII text file format

Open Microsoft Excel.
From the File menu, click Open.
In the Files of Type box, select Text Files (*.prn; *.text; *.csv).
Select the name of the export file you want to open and click Open.
Follow the Text Import Wizard to import the file into Microsoft Excel.
Under Delimiters, select Other and enter a quotation.
Make any modifications to the file to ensure that Working Papers can import it as an ASCII text file. Make sure that each field is in a separate column and that any heading lines are removed.
On the File menu, click Save As.
In the Save as Type box, select CSV (comma delimited) (*.csv) and then click Save.
On the File menu, click Exit.

Results

The file will be in ASCII format with a .csv extension and it can be imported into Working Papers using the ASCII text file import.