Importing Data into Excel from Easy InnKeeping


1. Open a worksheet in Excel and click the cell where you want to start the external data range.

2 On the Data menu, point to Get External Data, and then click Create New Query.

3 On the Databases tab, select the database from which you want to retrieve the data - Click on Innkeeper

4 Make sure the Use the Query Wizard to create/edit queries check box is selected, and then click OK.



    IF MS QUERY BUTTON IS GRAYED OUT, YOU WILL NEED TO RE-INSTALL MICROSOFT WORD. SEE BELOW FOR INSTRUCTIONS.

    1. When re-installing Microsoft Word, you will see a screen in the wizard that lists all the office programs.
    2. Highlight Data Access in this list and click on "Options" button.
    3. In the Options list make sure "Microsoft Query" is checked.
    4. Continue with the wizard to complete re-install.

  1. This brings the list of tables present in the database. Follow this chart of information for the reports you want:
    2.

    Reservation Financial Report

    reservation table

    Occupancy Report

    transaction table

    Revenue Report for Sales Items

    sales table

    Guest Addresses/Info

    guestinfo table
  2. Follow the instructions in the Query Wizard.

6 To return the data directly to Microsoft Excel, click Return Data to Microsoft Excel, click Finish, and then select where you want to put the external data.

To refine the query further, click View data or edit query in Microsoft Query, click Finish, and then make the changes you want. For more information about refining the results of a query, see Microsoft Query Help.

If you choose to refine the query further in Microsoft Query, the result set is displayed in Microsoft Query. If you want, you can return the result set to Microsoft Excel at a later time.

 

Notes

You can check the status of a query that's running in the background and taking a long time to return data. While the query is executing, click Refresh Status on the External Data toolbar. To cancel the query, click Stop Refresh.