Business

Replace content in MS SQL Server 2000 or 2005 database tables. Select one or many tables in which to make the replacement.

Delete duplicate entries in MySQL tables. Specify fields (columns) to use as criteria. All redundant entries are eliminated leaving behind only the one unique entry.

Delete duplicate entries in Oracle tables. Specify fields (columns) to use as criteria. All redundant entries are eliminated leaving behind only the one unique entry.

Use Excel as a front-end interface to a FoxPro database. Use Excel to import and export tables to and from FoxPro databases. Read and write tables to and from Excel without SQL knowledge. Connect to FoxPro via DBC file or multiple DBF files in a folder. Excel 2000 or higher required.

Define words by highlighting text. By default, Google's Define feature is used, but one can edit the link to use any site. Word 2000 or higher required.

Save MySQL tables as text or CSV files. In the resulting text file, each field (column) is separated by a comma or other specified character(s). Each row is separated by a new line. Specify which fields to save.

Transfer tables to and from MySQL and FoxPro databases. Importing and exporting can be done without SQL knowledge. Connect to FoxPro via DBC file or multiple DBF files in a folder.

Transfer tables to and from MS Access and PostgreSQL databases. Importing and exporting can be done without SQL knowledge. Access 2000 or higher required.

Convert MS SQL Server 2000 or 2005 data in one table to a XML file. Output can be fully customized to contain database field names as tags.

Apply a math operation (add, subtract, multiply or divide) of either a whole number or a decimal to a block of selected cells in MS Excel. Excel 2000 or higher required.