Delphi Display Systems, Inc. RDS-INSFTTCU
Page 78 of 82
Confidential Document:
Do not copy or distribute without written permission from Delphi Display Systems, Inc.
Copyright
2012. [Unpublished Work]. All rights reserved
6
Importing to Excel
This section will outline on how to import a Fast Track® data file to Microsoft Excel. However the steps
used in this outline could be used to import the data into most data base or spreadsheet type programs
.
1. From Microsoft Excel click on File from the Menu bar and select Open. An Open window will
appear in the body of the Excel screen.
2. L
ocated at the bottom in the Open window, select from the Files of Type drop down box “All Files
(*.*)”.
3. Locate the *.E_R report that you created, usually the report when created is located in a sub-
folder within the Fast Track program file folder, and open.
NOTE:
When creating the report, make sure you have checked the “Use Commas” box prior to
creating it. (
See
–
Section 4.11
Reports) Then Save the report. The Use Commas acts
as a separator to place the data in the appropriate fields in the spreadsheet
.
When you have selected
the report, the Text Import
Wizard will appear. Select
under “Original data type”
Delimited
and for “File
origin”
437 : OEM United
States
.
The next Text Import Wizard screen, check only
the
Comma
box for “Delimiters”.