MyDbf Studio is a multi-platform open source program made with Lazarus that will help you to manage your dbf tables. The main features are:
- You can work with multiple tables at once, in a tabbed user interface.
- You can directly add, modify or delete data.
- You can view deleted data.
- You can create, empty, delete, change or restructure a table.
- You can create, delete or modify any index in a table.
- You can add or substract two tables.
- You can directly export data in the following formats: CSV, HTML, XLS, DBF, XML or SQL script.
- It works on Windows, Linux and all platforms supported by Lazarus.
The application is distributed as source code. You must compile it with a recent Lazarus version, v2.0 or later.
The program originally was written by Enzo Antonio Calogiuri (aka Fog76), but since the original sources of v0.4.2 were no longer readily available I decided to put them onto my github and to refactor some places. Later Enzo published a v0.5 (https://forum.lazarus.freepascal.org/index.php/topic,8954.msg406180.html#msg406180), but since I had some ideas how to improve it I merged the new version and continued with this fork:
- Display memo and picture (.jpg, .png, .bmp, .ico) fields
- Display ansi characters from the table's code page correctly as utf-8.
- Store user settings and the names of recently loaded files in an ini file in the the user's home directory.
- Layout of the controls is determined by anchoring and autosizing and thus should work out in all operating systems supported. Form positions are stored in the ini file.
- Support drag and drop of dbf files from the operating system.
- Optionally, auto-fill the column of the DBGrid displaying the dbf file.
- Import from CSV files
- Sample files for "playing" (DeadlyMushrooms.dbf, country_codes.dbf).