• Sales > Report Generator
• Front Desk Operations > Guest History > Report Generator

              
Enter the dates and sort parameters.  In the "Report to generate" drop-down select "Export TAB delimited text file".   Click Generate Report.




When the file is created you will see a message stating that the file GAHMFILE.TXT has been created.  This is the file you will import into Excel.  The file will be located in your ExecuTech hotel folder on the server.  If you are not sure where this is located, look at your lower left Execu/Suite screen for the path to the hotel folder.

Excel Import 

You will launch Excel to import the GAHMFILE.TXT file.

The following instructions and images are general; your version of Excel may be different.  Use the Help feature within Excel if you need further assistance.

In some newer versions of Excel, go to Data > Get Data > Legacy Wizards > From Text (Legacy)

In some older versions of Excel, go to Data > Get External Data > From Text.



At the prompt, enter the file name GAHMFILE.TXT.  The location will be your ExecuTech Hotel folder.

Click Import (or Open)

When the import windows open, select "Delimited" and then click "Next".




Select "Tab" and then click "Next".

On step 3, you can decide which columns to import as well as the data format for each column (or you can select Finish to import everything then delete columns and change data format later.)

• You will select each column one at a time (the active one will turn black)
• If you do not want to import a column, select it and click on Do not import column (skip). Do this for each column you don't want imported (you may need to use scroll bar to see all columns.)
  The columns will now say Skip Column at the top of each one you selected.
• Next, you can decide the data format for the remaining columns by selecting each one at a time.
• When you are finished, click Finish.
  
  
  
  
  You are finished.  You may use the data however you wish within the parameters of Excel.