Print to File

This will show you how to print to file and to import the text file into excel

Your version of excel may vary from the one shown

1. Select Print
2. Tick Print to File
3. Select Text File from Drop Down List
4. Press Button to select location to save file to

1. Select Location to save your file to, this could be your desktop or My documents folder, or in this case the output folder on the server

2. Press Save

1. In Excel Select Open

1. Select the location you saved the file to

2. Select text Files from drop down

3. Select the file you saved from the list displayed

4. Select Open

In Text Import Wizard

1. Select Delimited

2. Select Next

1. Select Comma

2. Select " as the text qualifer

3. Select Next

1. Select General as the Format

2. Select Finish

The import is now complete

Comments (0)

Comments (0)