Data Flask is a spreadsheet program designed to support data authoring and migration. Data sources can range from basic text files, to remote SQL servers.
Once loaded into Data Flask, information can be viewed and modified using a common editing and automation interface. Like a traditional spreadsheet program, data imported into a Data Flask document (.dfg file) is an independent, disconnected copy of the data from the data source. Data is exported back to the data source with the explicit use of the Write Data command.
Unlike a traditional spreadsheet, Data Flask retains metadata (external), including column type, primary key identifiers, indexes and data link information. Boolean data types can appear as a checkbox, date columns have a calendar button, binary columns have a [hexadecimal] aware editor.
Data flask supports links to databases through the OleDb Agent. The Desktop Agent supports ANSI and Unicode text files through file, FTP and HTTP (read-only). Agents are .exa files responsible for importing and exporting data. Data flask comes standard with the Desktop and OleDb agent. The vendor notes that new Agents may be added either by Interscape, or a third party.
Flat file text support includes Unicode, [Binary] escape sequences, Line and Offset control.
Open UDL Data link files from Windows Explorer.
The "General" version is free, and online documentation and tutorials are provided. Uninstall leaves nothing behind if you decide not to continue using it.