Download Energy Audits - Weatherization Assistance Program Technical

Data Link - Database Linking, Importing and Exporting Data
the information differs considerably, making this a difficult feature to provide.]
Select the clients to be imported by clicking on rows containing their information in
the listing on the right of the screen, and using the other standard Windows item
selection procedures. For example, you can select multiple clients lying adjacent to
each other by clicking on the first or last, then holding down the [Shift] key while
using the [Up Arrow] or [Down Arrow] keys to select others. Holding down the
[Cntl] key while clicking on clients will allow you to select multiple clients which are
not next to each other. To assist in the selection process, you may sort the listings by
any of the client identifying criteria, using the “Sort list of clients by” combo box at
the lower left of the form. The sort may be performed in “Ascending” or
“Descending” order, depending on the selection made in the check boxes under
“Order” to the right of the combo box. The sorting will sort clients on both halves of
the form. In the figure at the beginning of this section, three clients have been
selected.
Once you have completed the selection, click on the left pointing arrow which
lies between the two halves of the form. The clients will be copied over into the
database file you are currently using and the Client IDs and associated information
will appear on the left half of the form. The status bar at the lower left of the form
will monitor the progress of the operation.
Exporting Clients (via database files)
Exporting is somewhat a reverse process to that described above. You can
export any set of clients in the database you are currently linked to and place them in
either another existing database or have a new database created just for the clients you
wish to export. However, if exporting to an existing database, the database must
have been formed using the same version of the Weatherization Assistant. No
"backward" compatibility has been provided.
To export clients, enter the “Transfer between databases” form, as described
above for importing clients. If you will be exporting clients to an existing database,
choose the database in the same manner you would chose a database for importing.
Otherwise, use the “Browse” button on the form to specify only a location on your
computer where you wish a new database to be created and enter the name of this new
database in the "File name" field at the bottom of the browse window. You may
choose to create a standard "mdb" database file or a zipped "wdz" file using the "Save
as type:" combo box at the bottom of the form or simply by giving the file the
appropriate extension, “mdb” or “wdz.” The "wdz" files are compressed to about one
Chapter Twelve • 180