Gasboy TopKAT Operation Manual - Manual (Page 144)

Appendix E: Loading TopKAT Files from Microsoft® Excel® Transferring Vehicle Records from Excel to TopKAT
Page E-4 MDE-4338A TopKAT™ Fuel Management System Operation Manual · February 2009
Transferring Vehicle Records from Excel to TopKAT
To transfer Vehicle Records from Excel to TopKAT, proceed as follows:
1 While in MS-Excel, highlight and copy all cells containing your vehicle information.
Do not copy row 1 and 2 headers. Be sure to copy columns A through N, as you cannot see all
columns displayed on one screen.
2 Open Microsoft Word ® .
3 From the menu bar, select Edit > Paste.
4 Using your mouse, click anywhere within the table area.
5 From the menu bar, select Table > Select Table.
6 From the menu bar, select Table > Convert Table to Text. Select the required Paragraph
marks and click OK.
7 Click on Align Left button on the menu bar.
8 Type the following at the top of the page:
A REC
V
Your screen should resemble the example shown below.
9 Save the file. Take note of where you have saved it.
10 From the menu bar, select File > Save As. Select Text only from the Save As Type list of
options. Click Save.
11 Select the file. You are now ready to send your file to your TopKAT system.