CONNECT TO DATABASE:

dBworxPE can import records directly from any database system that 
has ODBC capability.  You can connect to other database files 
(Access, DBF, etc.), using ODBC (Open DataBase Connectivity) and
query open tables using standard SQL statements.

To connect to another database you need to have a DSN (Data
Source Name) link set up for that file.  You can create a link by
following these steps:

  1) Click on "Start", then "Settings" and "Control Panel".
  2) Click on "ODBC Data Sources".
     (NOTE: If you don't see an icon for ODBC Data Sources, look for
                 one labeled "Administrative Tools" -- click on that and you
                 should see the ODBC icon).
  3) Click on the "USER DSN" tab if it's not selected.
  4) Click "Add".
  5) Click on the appropriate driver (Microsoft Access, Dbase, etc.).
  6) Click "Finish".
  7) Enter your data source name (the name of the database file you
      want to connect with).
  8) Enter a description (optional).
  9) Click "Select" and locate your database file.
 10) Your created link should appear on the User Data Sources list;
       click "OK" to end.   

Once you have a DSN link set up to a database dBworxPE can connect
to it at any time -- just follow these steps:

  1) Click on the "Files" menu, then click "Connect to Database"
  2) Enter the name of the database you're connecting to
  3) Enter the password (if one is required)
  4) Enter the name of the database table you want to open -- a screen
     will display showing the records in the database table
 
At this point you can type any valid SQL statement into the box
labeled "SQL", then click the "Exec SQL" button.  The SQL
statement you entered will then be executed against the database
records.

For example, let's say you're connected to a Microsoft Access
database that has a table called "Books" containing records for
various fiction and nonfiction books.  Assume that this table has a 
column named "Category" which is equal to either "Fiction" or 
"NonFiction" depending on the type of book.  To select just the
records for fiction books you would enter the following in the SQL 
statement box:

   SELECT * FROM Books WHERE Category = 'Fiction'

Click the "Exec SQL" button and any books that aren't in the 'Fiction'
category will be removed from the display.

At any time you can click the "Import" button and whatever records
are displayed will be added to the currently open dBworxPE file.  When
you're finished, click "Exit" to return to the main screen.