Use this program to search and delete duplicate data (values, records, rows and numbers) in your MS Access tables. All redundant entries are eliminated leaving behind only one unique instance. You select which fields (columns) to use as criteria.

Change case for values in MS Access tables. Change to upper case, lower case, title case (proper case), and sentence case. The data found in each field of a table can be quickly converted.

Join two or more fields (columns) into one in Microsoft Access. A wizard guides you through the process of selecting fields (in a table) to be merged. The values in the selected fields will be combined and put into a new field of your choice.

Search for and replace data (characters) in your Microsoft Access Banque de données tables. You decide which tables to make replacements in. Replacements are not made in special cases such as booleans (True/False) and primary keys.

Quickly clear out text, characters, spaces, enters and tabs from fields in MS Access using different methods. These methods include: removing spaces, removing alpha, numeric and more, removing characters after a word, etc.

Divide one field (column) into 2 or more in Microsoft Access. A wizard guides you through the process of selecting a table and field to be split. The values found in the field will be split and new columns will be added accordingly.

Convert CSV and text files into HTML files. Each line in the file creates a HTML row and each separating character in a line creates a HTML column.

Convert CSV files into XML files. Comma separated / delimited files may or may not have a header row on the first line. This application is simple to use and provides a few options to control how you want the XML output to appear.

Import many CSV files into one Excel file quickly. Load a list of CSV files into the program and the data will be inserted into a blank workbook.

Compare 2 Excel sheets / files and show the differences for each cell. The comparing process will produce a report that is easy to understand.

Use this application to find and extract emails in your Excel files. Save the results to a text file.

Use this application to search and modify text in your many Excel files. You no longer need to open up each individual file and search. This program will quickly make these mass changes in seconds.

Use this application to find and extract cell text in mulitple Excel files. Extract cells by the text they contain or by specific location such as C1, C2, C3. Extract between a starting and ending character in all cells. Save the results to file.

Merge / combine two Excel tables into one based on a common column of data from each table. A wizard makes the join process fast and easy. No complicated options. Rows from the two unequal tables will line up perfectly without copying and pasting.

Quickly clear out text, characters, spaces, enters and tabs from cells in MS Excel using different methods. These methods include: removing spaces, removing alpha, numeric and more, removing characters after a word, etc.

Break up names, addresses or any Excel cell text into many columns. Splits can be done by spaces, commas or any other character. Splits are done quickly through a wizard on a big or small block of cells that you select.

Import many text files into one Excel file quickly. Load a list of text files into the program and the data will be inserted into a blank workbook. Each line of the text file can be chopped up by a specific character to create new Excel columns.

Change case for values in MS SQL Server 2000 or 2005 tables. Change to upper case, lower case, title case (proper case), and sentence case. The data found in each field of a table can be quickly converted.

Use this program to search and delete duplicate data (values, records, rows and numbers) in your MS SQL Server tables. All redundant entries are eliminated leaving behind only 1 unique instance. You select which fields (columns) to use as criteria.

Search for and replace data (characters) in your MS SQL Server 2000 or 2005 Banque de données tables. You decide which tables to make replacements in.