From Ahadun: Solutions:
Compare gives you the ability to view/query/edit/update files which are currently in use by other applications, and the flexibility of scheduling when such tasks as data transfers and file updates take place.
Compare allows you to write and execute SQL queries on any local dBASE or Paradox database, and, via a LAN or established Internet (TCP/IP) connection, execute SQL commands on remote (or local, 127.0.0.1) MS Access, SQL Server, or other SQL databases, to insert, update or retrieve data. You may also retrieve data from remote spreadsheets or text files, and save the data as a table in Compare's Access database. Then, from within Compare, you can open, edit, re-save, or delete tables. You can also use the SQL 'INTO' clause to create new tables in Compare's database. Save the SQL statements you write, and re-use them at a later time.
Compare lets you easily manipulate data in local (or remote, via a mapped drive) dBASE, or Paradox databases, whether two fields in one database or one field in two databases. Compare gives you the ability to specify various criteria, and processes fields based on those criteria. For example: If data in File A is equal/not equal/greater than/less than/before/after data in File B/entered data, delete data in File B/A; replace data in [any field] with data from [any field] (or entered data); or export fields in File A/B to a file you select.
If files to be exported from have field names in common, and the fields are selected from both files, Compare can re-create a table in its database with the fields you selected to export from, and additional fields to hold data that is to be exported from the duplicate field(s). You will then be able to VIEW/Edit the table, save it as a name of your choice, and re-open it for editing or delete it at a later time. Alternatively, Compare can create a new record, in the file you open to export to, each time data from a duplicate field must be written.