Remove or replace certain characters, spaces, enters, tabs or user-defined from fields (columns) in Oracle using different methods. Remove character(s) to beginning, end or inside by position or by referencing surrounding character(s).
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.
Save MS SQL Server tables as text or CSV files. In the resulting text file, each field (column) is separated by a comma or other specified character. Each row is separated by a new line. Specify which fields to save in the table.
Save MS Access 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. Access 2000 or higher required.
Remove or replace certain characters, spaces, enters, tabs or user-defined in fields (columns) in MS SQL Server 2000 or 2005 using different methods. Remove character(s) at beginning, end or inside by position or by referencing surrounding character.
Remove or replace certain characters, spaces, enters, tabs or user-defined in a field (column) in MySQL using different methods. Remove character(s) at beginning, end or inside by position or by referencing surrounding character(s).
Load text or CSV files into a MS SQL Server database. Create a new table or append to an existing table.
Transfer tables to and from MS Access and Oracle databases. Importing and exporting can be done without SQL knowledge. Access 2000 or higher required.
Add text to beginning, end or inside of all entries in a field (column) in a MS Access table. Add text by position or by referencing surrounding character(s). Access 2000 or higher required.
Change case in Oracle tables. Change to upper, lower, title (proper) or sentence case. Case of each word in each field (column) is changed.
Change case in MS SQL Server 2000 or 2005 tables. Change to upper, lower, title (proper) or sentence case. Case of each word in each field (column) is changed.
Use MS Excel as a front-end interface to a Oracle database. Use Excel to import and export tables to and from a Oracle database. Read and write tables to and from Excel without SQL knowledge. Excel 2000 or higher required.
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.
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.
Convert MySQL data in one table to an XML file. Output can be fully customized to contain database field names as tags.
Join two or more fields (columns) into one in MS Access. The content in the specified fields will be combined and put into a new field. Access 2000 or higher required.
Divide one field (column) into 2 or more in MS Access. The contents of a specified field will be split (by a separating character such as a space, comma or other character) and placed into the correct number of new fields. Access 2000 or higher.
Remove or replace certain characters, spaces, enters, tabs or user-defined in a field (column) in MS Access using different methods. Access 2000 or higher required.
Replace content in MS SQL Server 2000 or 2005 database tables. Select one or many tables in which to make the replacement.
Replace content in MySQL database tables. Select one or many tables in which to make the replacement.
Delete duplicate entries in MS Access tables. Select fields (columns) to use as criteria. All redundant entries are eliminated leaving behind only the one unique entry. Access 2000 or higher required.
Delete duplicate entries in MS SQL Server 2000 or 2005 tables. Specify fields (columns) to use as criteria. All redundant entries are eliminated leaving behind only the one unique entry.
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.
Extract fields (columns) that contain specific text in MS SQL Server databases. Extract parts of a field by specifying starting and ending character(s). Extractions are executed on all tables in the database.
Extract fields (columns) that contain specific text in MySQL databases. Extract parts of a field by specifying starting and ending character(s). Extractions are executed on all tables in the database.
Replace content in MS Access tables. Select one or many tables in which to make the replacement. Replacements are not made in boolean (Yes/No) datatypes and primary keys. Access 2000 or higher required.
Extract email addresses in one or many MS Access databases. Emails are saved as a text file. Access 2000 or higher required.
Extract entries that contain specific text in one or many MS Access databases. Extract parts of an entry by specifying starting and ending character(s). Extractions are executed on all tables in the database. Access 2000 or higher required.
Horizontally merge two MS Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. Access 2000 or higher required.
Change case in MS Access tables. Change to upper, lower, title (proper) or sentence case. Case of each word in each specified field (column) is changed. Access 2000 or higher required.