From the developer: "Compare allows you to write and execute SQL queries on any local dBASE or Paradox database, and, via an Internet connection, execute SQL commands on remote 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, 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 also allows you to easily manipulate data in dBASE (.dbf), or Paradox (.db) 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 Field A/B with data in Field B/A/whatever; or export fields in File A/B to a file you select."