Printing Reports to File to Access Via Excel

The purpose of this lesson is to print reports to a text file which can then be opened by excel

1. Within the print preview select Print

2. Tick the Print to File Box

3. Select Text file as the file type

4. Press selection box at the end of the where field to save the file into a location that is easy to access

1. Select Desktop to save the file on your desktop OR 2. Enter your own location to save this file to

3. Press Save to save file

1. The location you are going to save the file in will appear in Box 1, once you are happy with that proceed to step 2

2. Press OK to run report to file

Opening with Excel

PLEASE NOTE WE DO NOT SUPPORT EXCEL QUERIES AND YOUR VERSION OF EXCEL MAY VARY FROM ONE SHOWN

1. Click on Office Button

2. Select Open

1. Go to the location you saved the file into

2. Select text files as the type of file to search for

3. Select the Report for the list of files available

1. Select Delimited

2. Select Next

1. Change Delimited to Comma

2. Select Next

1. Select Finish

The data is now imported into Excel

Comments (0)