The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.
Read the rest of this entry »

• 0 Comments

There are several ways to import Microsoft Access tables into SAS. They are as follows:
1) Using SAS/ACCESS to ODBC:
1) SAS/CORE, SAS/BASE and SAS/ACCESS interface to ODBC licensed and installed at your site.
2) The Microsoft Access ODBC driver must be installed and configured on your PC.
3) Use the following code to read the Microsoft Access file into a SAS dataset. Libname sasuser ‘c:\foo’;
Read the rest of this entry »

• 0 Comments

The launch of OpenOffice.org 1.0 in 2002 removed at a stroke one major obstacle to the universal use of Linux on the desktop. At last, Linux users have office software - word processor, spreadsheet, graphics, and presentation - which not only works at least as well as the Microsoft Office equivalent, but can also use Microsoft Office file formats, and is genuinely open source.
Read the rest of this entry »

• 0 Comments

In this document, we describe a simple application that keeps track of payments made to client accounts. Setup: The current version of the application is configured to use an HSQLDB database (although connections to a MySQL database and an MS Access database are also included in comments at the beginning of ClientBillingDB.java).
Read the rest of this entry »

• 0 Comments