Disclaimer
This information is provided "as is" and without any warranties of any kind, whether express, implied or statutory, including, without limitation, any implied warranty of merchantability or fitness for a particular purpose. Pacific Rentals Solutions, Inc. shall not be liable for any direct, indirect, special, incidental or consequential damages which arise in connection with this information, and this limitation of liability will apply regardless of the form of action. The entire risk with respect to this information rests with you, and we suggest that you thoroughly evaluate the information before it is relied upon or used in any way.
Description
It is possible to view RCMS tables in Microsoft Excel by using an ODBC connection. Only use an ODBC connection to view RCMS tables, if you write data back to RCMS there is no validation done and it can cause errors and/or corrupt your installation.
Instructions
First, you will need to download and set up an
ODBC connection to the database:
- Download the VFP ODBC driver (vfpodbc.msi)
from the following website:
http://download.microsoft.com/download/vfoxodbcdriver/Install/6.1/W9XNT4/EN-US/VFPODBC.msi - Double-click this file to execute the Microsoft installer package.
- Click Start and Control Panel.
- Double-click Administrative Tools.
- Double-click Data Source (ODBC). The ODBC Data Source Administrator screen should appear.
- Click User DSN.
- Click Add. The Create New Data Source screen should appear.
- Select "Microsoft Visual FoxPro Driver."
- Click Finish. The ODBC Visual FoxPro Setup screen should appear.
- Type "RCMS" into the Data Source Name field.
- Select "Visual FoxPro Database" for Database
type. Set the Path to the Prodata.dbc file in the root folder of
RCMS (usually named Pro73 or Pro73sbe). - Click OK.
The ODBC VFP connection is complete.
To open RCMS table in MS Excel:
- Have Excel open with a blank worksheet
- Go to Data > Import External Data > Import Data
- Select "+Connect to New Data Source.odc"
- Select ODBC DSN and click Next
- Select "RCMS" and click Next
- Select the RCMS Table you want to open and
click Finish. Popular tables are:
RCMAST - Master Item Table
RCITEM - Asset Item Table
ARCUST - Customer Table
ARMAST - Current Invoice Header
ARTRAN - Current Invoice Details
RCCNHD - Current Contract Header
RCCNDT - Current Contract Details
- Select Existing Worksheet and click OK
