AbsoluteSQL

general purpose database tool based on the ComponentAce Absolute Database Engine

Database format: Absolute Database.
Comprehensive SQL capabilities.
Zero installation, zero setup, zero maintenance, no DLLs.
Import: BDE (dBase, Paradox, etc.). Delimited Text import (CSV or tabbed; UTF-8/Unicode enabled).
Export: MS Excel. Delimited Text export (CSV or tabbed, UTF-8/Unicode enabled, user selectable ISO Date/DateTime export).
Import/export delimiter: comma, semicolon, tab. Text qualifier: double quotes (optional with export).
ISO Date/DateTime text export optionally overriding system settings.
Dependencies: None. Uses Borland Database Engine (BDE) during import if importing BDE-dependent data (dBase, Paradox).
OS: Windows XP, Vista, 7, 8, 10. 32- and 64-bit.
Bugfix: Error on loading MIDAS.dll on certain computers solved (dec. 31 2018).

Data portability: Existing data structure and data can at any time be recreated via full reverse SQL table structure and data definition being fully portable to any SQL competent database system.
Portability to MS Access: As MS Access does not support SQL scripts (sequentially executed SQL statements) Access will depend on table creation from SQL table structure definition and subsequent data import from e.g. delimited text data files.

Download, freeware (no restrictions, no limits, no adds): AbsoluteSQL.zip (31.12.2018)


DATE and TIMESTAMP provided dd/MM/yy vs. MM/dd/yy sequence adapts to the locally used Windows settings.
ISO-format date imports as current Windows date format whatever the current Windows setting.