Access RezEasy Front Desk Data in Microsoft Office

You can access data from RezEasy Front Desk database in Microsoft Office applications, such as Microsoft Excel or Microsoft Word, using the Visual FoxPro OLE DB Provider.

OLE DB Provider for Visual FoxPro

The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access RezEasy Front Desk databases and tables from other applications. You can download VfpOleDB.dll from Microsoft website.

To connect to a Visual FoxPro database or table in Excel

1. Open an Excel worksheet.
2. From the Data menu, point to Import External Data, and click Import Data.
3. In the Select Data Source dialog box, click New Source Data Connection.
4. In the Data Connection Wizard, select Other/Advanced.
5. In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.

The Connection tab in the Data Link Properties dialog box appears.

To connect to a Visual FoxPro database or table in Word

1. Open a Word document.
2. From the View menu, point to Toolbars, and click Database.
3. On the Database toolbar, click the Insert Database icon.
4. In the Database dialog box, click Get Data.
5. In the Select Data Source dialog box, click New Source Data Connection.
6. In the Data Connection Wizard, select Other/Advanced.
7. In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.

The Connection tab in the Data Link Properties dialog box appears.

To add a Visual FoxPro database or table folder

1. On the Connection tab and in the Select or enter a database name box, type path and name of the database or table folder you want.
   -or-
   To browse for a Visual FoxPro database or table folder, click the ellipsis (...) button to the right of the Select or enter a database name box to open the Configure Connection dialog box.
2. Specify a different collating sequence if desired.
3. To test the connection, click Test Connection. If connection is successful, click OK.

Create Custom Reports in RezEasy Front Desk

You can create custom reports from RezEasy Front Desk using Crystal Reports which is available from ReCrystallize.com

Crystal Reports access RezEasy Front Desk via the Visual FoxPro OLE DB Provider. You must download and install this driver from Microsoft as described earlier in this page. Then follow the instructions in Crystal Reports to access RezEasy.