Creating a dbf file from excel - VBA. Data conversion from Microsoft Excel to DBF format Data search and filtering tools

how to create a dbf file from excel using ADO in ADO I got confused ...... exactly in specific information .... 1. connection to dbf (and what else can be connected to with the help of ado and how); 2.creating a dbf file (other options); 3.record; 4.saving; 5.closing. thanks for any info

what to look for on this topic or complete ignore ..... on the topic of ADO, it can be better to create a topic ..... extensive use of ADO

poor as it turns out

Code for the task: "Creating a dbf file from excel"

textual

Program listing

"::: Step 1 - Determine where we're running homeDir=Wscript.ScriptFullName "::: This is - full path our file k=Instrrev(homeDir,"\") "::: Look for "\" from the end homeDir=left(homeDir,(k-1)) "::: This is the clean directory name "::: Step 2 - Create an ADO connection and an empty recordset Set Conn = CreateObject("ADODB.Connection") Set RS = CreateObject("ADODB.Recordset") DSNName = "DRIVER=Microsoft dBase Driver (*.dbf);DBQ=" DSNName = DSNName & HomeDir "::: Stage 3 - Open the connection Conn.Open DSNName "::: Stage 4 - prepare the SQL statement to create the table SQL="create table Testtable (N1 Float, N2 Float)" "::: Stage 5 - execute it RS.Open sql,Conn,3,3 "::: Step 6 - Add 100 records to the table For i=1 to 100 SQL="insert into testtable values ​​(" & cstr(i) & "," & Cstr (2*i-1) & ")" RS.Open sql,Conn,3,3 Next "::: Step 7 - Summarize... SQL="Select sum(N1),sum(N2) from Testtable" RS .Open SQL,Conn,3,3 SS1=RS(0) SS2=RS(1) MsgBox SS1 MsgBox SS2 Rs.Close SQL="Drop table Testtable" RS.Open sql,Conn,3,3 MsgBox "Table dropped! "

DBF is a popular format for storing and exchanging data between various programs, and primarily between applications that serve databases and spreadsheets. Although it has become obsolete, it continues to be in demand in various fields. For example, they continue to actively work with him accounting programs, and regulatory and government authorities accept a significant part of the reports in this format.

But, unfortunately, Excel, starting with the version of Excel 2007, stopped full support specified format. Now, in this program, you can only view the contents of the DBF file, and the built-in application tools will no longer be able to save data with the specified extension. Fortunately, there are other options for converting data from Excel programs in the format we need. Let's see how this can be done.

In Excel 2003 and in earlier versions of this program, it was possible to save data in DBF (dBase) format in a standard way. To do this, you had to click on the item "File" V horizontal menu application, and then in the list that opens, select the position "Save as…". In the saved window that opened, you had to select the name of the desired format from the list and click on the button "Save".

But, unfortunately, since the version of Excel 2007, Microsoft developers have considered dBase obsolete, and modern Excel formats are too complex to spend time and money on providing full compatibility. Therefore, Excel remained able to read DBF files, but support for saving data in this format by built-in software tools was discontinued. However, there are some ways to convert data saved in Excel to DBF using add-ins and other software.

Method 1: WhiteTown Converters Pack

There are a number of programs that allow you to convert data from Excel to DBF. One of the most simple ways To convert data from Excel to DBF is to use a package of utilities for converting objects with a different WhiteTown Converters Pack extension.

Although the installation procedure for this program is simple and intuitive, we will nevertheless dwell on it in detail, pointing out some of the nuances.

1. After you have downloaded and launched the installer, a window immediately opens Installation wizards, which prompts you to select a language for the further installation procedure. By default, the language that is installed on your instance of Windows should be displayed there, but you can change it if you wish. We will not do this and just press the button OK.



2. Next, a window is launched in which the location on the system drive where the utility will be installed. By default this is a folder "Program Files" on disk "C". Here it is also better not to change anything and press the key "Further".



3. Then a window opens in which you can choose exactly which transformation directions you want to have. By default, all available conversion components are selected. But some users may not want to install all of them, as each utility takes up hard drive space. In any case, it is important for us that there is a check mark next to the item XLS (Excel) to DBF Converter. The user can choose to install the remaining components of the utility package at his discretion. After the setting is done, do not forget to click on the button "Further".



4. After that, a window opens in which a shortcut is added to the folder "Start". By default, the label is named "Whitetown", but you can change its name if you wish. Click on the key "Further".



5. It then launches a window that asks whether to create a shortcut on the desktop. If you want it to be added, then leave a checkmark next to the corresponding parameter, if you do not want it, then uncheck it. Then, as always, press the key "Further".



6. After that, another window opens. It contains the basic installation options. If something does not suit the user, and he wants to edit the parameters, then he should press the button "Back". If everything is in order, then click on the button "Install".



7. The installation procedure begins, the progress of which will be displayed by a dynamic indicator.



8. Then an information message is displayed on English language expressing gratitude for the installation this package. Click on the key "Further".



9. In the last window Installation wizards it reports that the WhiteTown Converters Pack has been successfully installed. We just have to press the button "Complete".



10. After that, a folder called "Whitetown". It contains shortcuts to utilities for specific conversion areas. Open this folder. Before us appears a large number of utilities included in the WhiteTown package in various areas of conversion. Moreover, each direction has a separate utility for 32-bit and 64-bit operating systems. Windows systems. Open the application with the name XLS to DBF Converter, corresponding to the bitness of your OS.



11. The XLS to DBF Converter program starts. As you can see, the interface is in English, but, nevertheless, it is intuitive.

    Tab opens immediately "Input" ("Input"). It is intended to indicate the object to be converted. To do this, click on the button Add ("Add").



12. After that, the standard window for adding an object opens. In it, you need to go to the directory where the Excel workbook we need is located with the xls or xlsx extension. After the object is found, select its name and click on the button "Open".



13. As you can see, after that the path to the object was displayed in the tab "Input". Click on the key Next ("Further").



14. After that, we automatically move to the second tab "Output" ("Conclusion"). Here you need to specify in which directory the finished object with the DBF extension will be displayed. In order to select the folder for saving the finished DBF file, click on the button "Browse..." ("View"). A small list of two items opens "Select File" ("Select a file") And "Select Folder" ("Select Folder"). In fact, these items only mean choosing a different kind of navigation windows to specify the save folder. We make a choice.



15. In the first case it will be a normal window "Save as…". It will display both folders and already existing dBase objects. Go to the directory where we want to save. Further into the field "File name" specify the name under which we want the object to appear after conversion. After that click on the button "Save".

    

    If you choose the option "Select Folder", a simplified directory selection window will open. It will only show folders. Select a folder to save and click on the button OK.



16. As you can see, after any of these actions, the path to the folder for saving the object will be displayed in the tab "Output". To go to the next tab, click on the button Next ("Further").



17. IN last tab Options ("Options") there are a lot of settings, but we are most interested in Type of memo fields ("Memo field type"). Click on the field in which the default setting is Auto ("Auto"). A list of dBase types for saving the object opens. This parameter is very important, since not all programs that work with dBase can process all types of objects with this extension. Therefore, you need to know in advance which type to choose. There is a choice of six different types:
    • dBASE III;
    • FoxPro;
    • dBASE IV;
    • Visual FoxPro;
    • >SMT;
    • dBASE Level 7.

    We make a choice of the type that is needed for use in a particular program.



18. After the choice is made, you can proceed to the direct conversion procedure. To do this, click on the button Start ("Start").



19. The conversion process starts. If there are several data sheets in the Excel workbook, then a separate DBF file will be created for each of them. A green progress indicator will indicate the completion of the conversion process. After he reaches the end of the field, click on the button Finish ("Finish").

The finished document will be located in the directory that was specified in the tab "Output".

The only significant drawback of the method using the WhiteTown Converters Pack is that it will be possible to carry out only 30 conversion procedures for free, and then you will have to purchase a license.

Method 2: Add XlsToDBF

You can convert an Excel workbook to dBase directly through the application interface by installing third-party add-ons. One of the best and most convenient of these is the XlsToDBF add-in. Consider the algorithm for its application.

1. After downloading the XlsToDBF.7z archive with the add-on, we unpack an object called XlsToDBF.xla from it. Since the archive has a 7z extension, unpacking can be done either standard program 7-Zip for this extension, or using any other archiver that supports working with it.



2. After that, launch the Excel program and go to the tab "File". Moving on to the section "Options" through the menu on the left side of the window.



3. In the settings window that opens, click on the item "Add-ons". We move to the right side of the window. At the very bottom is a field "Control". We rearrange the switch in it to the position "Excel Add-Ins" and click on the button "Go...".



4. A small add-on management window opens. Click on the button "Review…".



5. The window for opening the object is launched. We need to go to the directory where the unpacked XlsToDBF archive is located. We go into the folder under the same name and select the object with the name "XlsToDBF.xla". After that click on the button OK.



6. Then we return to the add-ons management window. As you can see, the name appeared in the list "XLS -> DBF". This is our add-on. There should be a check mark next to it. If there is no checkmark, then put it, and then click on the button OK.



7. So, the add-on is installed. Now we open an Excel document, the data from which needs to be converted to dBase, or we simply type them on a sheet if the document has not yet been created.



8. Now we will need to do some data manipulation to prepare it for conversion. First of all, we add two lines above the table header. They must be the very first on the sheet and have their names in the vertical coordinate bar. "1" And "2".

   In the uppermost left cell, enter the name that we want to assign to the created DBF file. It consists of two parts: the name itself and the extension. Only Latin alphabet is allowed. An example of such a name is UCHASTOK.DBF.



9. In the first cell to the right of the name, you need to specify the encoding. There are two encoding options using this add-on: CP866 And CP1251. If the cell B2 empty or set to any value other than "CP866", the default encoding will be CP1251. We put the encoding that we consider necessary or leave the field empty.



10. Then we move on to the next line. The fact is that in the dBase structure, each column, called a field, has its own data type. There are such designations:
    • N(Numeric) - numeric;
    • L(Logical) – logical;
    • D(Date) – date;
    • C(Character) - string.

    Also, in the string ( cnnn) and numeric type ( Nnn) after the name in the form of a letter, the maximum number of characters in the field should be indicated. If decimal places are used in the numeric type, then their number must also be specified after the dot ( Nnn.n).

    There are other data types in dBase format (Memo, General, etc.), but this add-on does not know how to work with them. However, Excel 2003 could not work with them either, when it still supported conversion to DBF.

    In our particular case, the first field will be a 100 character wide string ( C100), and the rest of the fields will be numeric, 10 characters wide ( N10).



11. The next line contains the names of the fields. But the fact is that they must also be entered in the Latin alphabet, and not in the Cyrillic alphabet, as we have. Also, spaces are not allowed in the field names. Rename them according to these rules.



12. After that, data preparation can be considered completed. We select on the sheet with the cursor with the left mouse button pressed the entire range of the table. Then go to the tab "Developer". By default, it is disabled, so before further manipulations, you need to activate it and enable macros. Further on the ribbon in the settings block "Code" click on the icon "Macros".

    You can make it a little easier by typing a combination of hot keys Alt+F8.



13. The macro window is launched. In field "Macro Name" enter the name of our add-in XlsToDBF without quotes. The register is not important. Next, click on the button "Run".



14. The macro does the processing in the background. After that, in the same folder where the original Excel file is located, an object with the DBF extension will be generated with the name that was specified in the cell A1.

As you can see, this method is much more complicated than the previous one. In addition, it is very limited in terms of the number of field types used and object types created with the DBF extension. Another disadvantage is that the dBase object creation directory can only be assigned before the conversion procedure, by moving directly to the destination folder source Excel file. Benefits this method it can be noted that, unlike the previous version, it is absolutely free and almost all manipulations are performed directly through the Excel interface.

Method 3: Microsoft Access program

Although new versions of Excel do not have a built-in way to save data in DBF format, but, nevertheless, the option using Microsoft applications Access is closest to being called standard. The fact is that this program is released by the same manufacturer as Excel, and is also included in Microsoft package office. In addition, this is the safest option, since you will not need to contact software third party manufacturers. Microsoft Access specifically designed to work with databases.

1. After all the necessary data on the sheet in Excel is entered, in order to convert them to DBF format, you must first save in one of Excel formats. To do this, click on the icon in the form of a floppy disk in the left upper corner program windows.



2. The save window opens. Change to the directory where we want the file to be saved. It is from this folder that it will then need to be opened in Microsoft Access. The format of the book can be left by default xlsx, or you can change it to xls. In this case, this is not critical, since we still save the file only to convert it to DBF. After all the settings are done, click on the button "Save" and close the Excel window.



3. We launch the Microsoft Access program. Go to tab "File" if it's open in another tab. Click on the menu item "Open" located on the left side of the window.



4. The file open window is launched. We go to the directory where we saved the file in one of the Excel formats. To display it in the window, move the file format switch to the position "Excel workbook (*.xlsx)" or « Microsoft Excel(*.xls)", depending on which one the book was saved in. After the name of the file we need is displayed, select it and click on the button "Open".



5. A window opens "Link to Spreadsheet". It allows you to most correctly move data from an Excel file to Microsoft Access. We need to select the Excel sheet from which we are going to import data. The fact is that even if the Excel file contained information on several sheets, then you can only import it into Access separately and, accordingly, then convert it to individual files dbf.

   It is also possible to import the information of individual ranges on sheets. But in our case it is not necessary. Set the switch to position "Sheets", and then select the sheet from which we are going to take the data. The correctness of the information display can be viewed in the lower part of the window. If everything satisfies, click on the button "Further".



6. In the next window, if your table contains headers, you need to check the box next to "The first row contains the column headings". Then click on the button "Further".



7. In the new spreadsheet link window, you can optionally change the name of the linked item. Then click on the button "Ready".



8. After that, a dialog box will open, in which there will be a message that the linking of the table to the Excel file is completed. Click on the button OK.



9. The name of the table that we assigned to it in the last window will appear on the left side of the program interface. Double click on it with the left mouse button.



10. After that, the table will be displayed in the window. Moving to tab "External Data".



11. On the ribbon in the toolbox "Export" click on the caption "Additionally". In the list that opens, select the item "dbase file".



12. The Export to DBF window opens. In field "File name" you can specify the file storage location and its name if the default ones do not suit you for some reason.

    In field "File format" choose one of three types of DBF format:

    • dBASE III(default);
    • dBASE IV;
    • dBASE 5.

    It should be noted that the more modern the format (the higher the serial number), the more opportunities there are for processing data in it. That is, there is a higher probability that all table data will be saved in the file. But at the same time, it is less likely that the program where you are going to import a DBF file in the future will be compatible with this particular type.

    After all the settings are set, click on the button OK.



13. If an error message appears after that, then try exporting the data using a different type of DBF format. If everything went well, a window will appear informing you that the export was successful. Click on the button "Close".

The created file in dBase format will be located in the directory specified in the export window. Further, you can perform any manipulations with it, including importing it into other programs.

As you can see, despite the fact that modern versions of Excel do not have the ability to save files in DBF format with built-in tools, nevertheless, this procedure can be done using other programs and add-ons. At the same time, it should be noted that the most functional way to convert is to use the WhiteTown Converters Pack utility set. But, unfortunately, the number of free conversions in it is limited. The XlsToDBF add-on allows you to convert absolutely free, but the procedure is much more complicated. In addition, the functionality of this option is very limited.

The "golden mean" is a method using Access programs. Like Excel, it is a development of Microsoft, and therefore third party application you can't call him anymore. Besides this option allows you to convert excel file into several types of dBase format. Although, according to this indicator, Access is still inferior to the WhiteTown program.

A free universal DBF editor that allows you to open existing and create new databases. It has a very small size, can be run from a flash drive and at the same time has many advanced tools for working with DBF files, among which there is even support for SQL queries!

Screenshot gallery

Usually on the site we cover programs that will be of interest to a wide range of readers, but today the case is not quite ordinary :). I used to work as a kind of "computer specialist" in several government offices and there I often had to deal with various programs based on FoxPro ...

The main problem with all these applications was that a simple user could easily screw up the database so that it could not be opened later. regular means, so I had to pervert to bring it back to life (which did not always work, given the "abilities" of "wild users" :)).

And now, a few years later, as I no longer work there, they sent us an email requesting to add a new free program for editing DBF databases, which has a simple name - Sdbf. Let's talk about her :)

Comparison with a paid analogue

Sdbf, despite its portability (it can work from a flash drive!) and small size, is a fairly advanced database editor that allows you to create, edit and export any DBF format databases, from the xBaseIII specification to the modern xVisualFoxPro! Let's compare the functionality of Sdbf with the capabilities of one of the most advanced editors of this kind, DBF Commander Professional:

From the table above, we can see that the programs differ slightly in functionality, but Sdbf, firstly, is portable (which is usually important, since every computer master prefers to carry a set of necessary programs on a flash drive), and secondly, it is completely free!

First run of Sdbf

To run the program, just unpack it from the downloaded archive to any location and open the resulting EXE file. An empty window of the following type will appear in front of us:

Drag & Drop, alas, is not supported, so to get started we need to call the "File" menu and there already select one of the two available actions: "Create" new base or "Open" an existing one. Let's open the existing database:

We will see the contents of the selected database in the form of a table. The "zero" line displays the names of the fields, and starting from the first - the content itself. Below the content at the bottom is the toolbar and status bar.

The latter displays quite a lot of useful service information, including the number of records in the database, encoding, creation date and automatically defined format. Of the Sdbf formats, it does not support only early versions xBase (I and II) and allows you to open and create DBF files of the following types:

• xBase III - VII;
• xClipper;
• xFoxPro;
• xVisualFoxPro.

Data search and filtering tools

Sdbf program allows you to directly edit any cell open base data, however, the necessary cells still need to be found ... If the database is small and unpretentious, then this can be done quite quickly and manually. However, if there are several tens or even hundreds of records, then it can be quite difficult to search.

But this is not such a problem, because Sdbf has several tools at once that allow you to filter out unnecessary data and display only what you need!

These tools are found on the bottom toolbar. Here comes 8 first navigation buttons, which allow you to move around the database (arrows), add/delete entries, and confirm or cancel changes. The functions we need begin with the ninth button - "Search":

When the button is activated, a small window with a search form appears in front of us. We need to specify the text to be found and select the field to be searched from the drop-down list. Now we press the "Find next" button and the program will automatically select the line following the current selection, which contains the searched text. Pressing the button again will highlight the line below the current one, which contains the same search data, and so on.

Sometimes in databases there is non-standard cell formatting: extra spaces, tabs and other characters that are not visually displayed, but affect the search result. If you are faced with such a case, then for the function to work normally, it will be enough for you to uncheck the "According to the format" checkbox in the lower central part of the search box and the searched strings will begin to be displayed.

The search function is useful when we need to quickly find single occurrences of specific data. But there are times when it would be more convenient to display several rows at once, which contain only certain information. In this case, the second function will help us (the button of which comes immediately after the search button) - "Filter":

To enable filtering, we first need to correctly compose a request and enter it in a specially designated field (immediately after the button in the central part of the toolbar). The principle of making a request is simple, but not entirely obvious. We need to first enter the name of the field by which we want to filter the database table, and then equate the filter value to the specific text by which we need to find all rows.

We take the value in single quotes, after which we press the “Filter” button itself (it becomes clamped) and we get a table containing data only with the values ​​\u200b\u200bdefined to us in the specified fields (in the example, we filtered all rows with the value “U.S.A” in the “Country” field (the case of specifying the name does not matter)). You can return the table to its original form simply by pressing the "Filter" button again (it becomes pressed again).

The filtering field can contain the simplest conditions "and" (to refine the query on several fields) and "or" (for alternative selection of data from different fields). Unfortunately, Sdbf does not support exclusive queries (such as "not"), but we can get around this limitation in another way, which will be discussed below.

By the way, in order not to manually enter a filtering request, you can use the following trick: select any entry in the field by which you will filter and press the Alt + F key combination (but not F4 :))). The request will be automatically generated, and the value will contain the "*" sign, which is a search mask and matches any number of any characters.

Alas, this is the only mask type that can be used in Sdbf and, even sadder, one request can contain only one mask :(. Therefore, if you need to filter the same field by several parameters, you will have to use the "and" operator (quick query generation by pressing "CTRL+ALT+F") or "or" ("SHIFT+ALT+F").

Executing SQL queries against database tables

Search and filtering is undoubtedly good, but not always convenient. When the number of records is large, we can easily lose sight of the data we need when parsing tables. However, in this case, Sdbf has a great feature - support for SQL queries!

With these queries in Sdbf we can:

1. Dynamically format our table, creating a selection only for certain required fields (SELECT and SELECT TOP statements);
2. Copy data from one database to another (INSERT FROM and INSERT INTO);
3. Change and delete the contents of certain lines (UPDATE and DELETE, respectively);
4. Group parallel requests (UNION);
5. form pivot tables(PIVOT).

To start working with queries, we need to click the "SQL Query" button at the right end of the toolbar. However, the result of such an action will be somewhat discouraging: the contents of the just edited database data will be lost, and another empty window with two fields will appear on top of the working window (at the top is the data output field, and at the bottom is the input field).

You should not be afraid :). You just need to immediately enter the desired SQL query in the lower field indicating the name of the desired database. If you do not remember this name, you can activate the Sdbf sidebar (by clicking on the gray vertical bar on the right), which displays all the bases that you have opened before in a list:

Also, to speed up the work, it is desirable to remember the hot keys, which can be viewed by calling the help by pressing the F1 key. There are only three of them, but they can significantly speed up the process of creating the right queries.

So, the combination "CTRL + Space" - will display a pop-up window with a list of available database names (so as not to look at the sidebar), "CTRL + F" - will display a list of functions for the current operator, and "CTRL + Enter" will start the query execution process . Also, if you click on the input field right click mouse (call the context menu), then we will get a list of operators supported by Sdbf.

Let's go back to our previous screenshot and look at simple query which is compiled there. It is based on the "SELECT" statement, which means it returns a selection to us. The selection parameter is "*", which means the output of any data, however, we could specify there, separated by commas, the names of any fields of the database table.

The sample we looked at above is the simplest, but Sdbf allows you to run more complex queries. In the next screenshot, we will see a selection, a dynamically generated table consisting of fields that contain the names of customers, the city in which they live and the country. Moreover, customers are filtered by country of residence (U.S.A) and the results are displayed in alphabetical order:

If you disassemble given request, then we will see the method of selection already mentioned by me by the fields specified with a comma after SELECT statement. Further, the same indication of the database name, but now the request does not end there.

The next step is to list the functions of the main operator that will have to be performed as a result of processing the request. Here are two of them.

The first - "where" is similar to the filter we discussed earlier, and performs a similar action - it allows you to select only those records that match the condition.

The second function - "order by" is responsible for sorting the results by one of the fields (in this case, by the field with the client's name - "NAME") in alphabetical ("asc" parameter) or inverted ("desc") order.

Naturally, the above example is also quite primitive, but it reflects the general essence of creating and processing SQL queries. If you want to learn more about them, I advise you to read the manuals here: http://dimonchik.com/insert.html or https://www.sql.ru/articles/articles.aspx?g=SQL&s=0 .

By the way, the advantage of Sdbf is the ability to export the resulting table as a new database or as an HTML, RTF, or CSV file! To do this, just call the context menu of the table display field and select the appropriate item.

Additional functions from the menu bar

We have dealt with the main features of Sdbf, but this does not end there. A number of useful and even unique functions are hidden in the menu bar, the same one that we used to open the database :) So, many useful features(which sometimes allow you to do without SQL queries) you can use the "Table" menu:

Among other "useful things" such as changing the encoding and merging databases, at the very bottom we can find the "Change Structure" item. This item calls up an additional window in which we can completely change all the fields of the open table, add new ones, or delete sections that are no longer needed (the same window opens when creating a database from scratch).

Specifically, we can change the order of fields, their names, types, sizes (number of characters in a cell) and precision (bit depth - usually set automatically and depends on the field type).

The only thing to remember when editing (and especially creating) bases is that each type of base has its own sets of field types and they often (if you do not take into account the main N, C, D) are different. For example, xClipper databases do not support image fields (P, B), and xBase up to the seventh version does not support auto-increment fields (+). That is, you must always remember about compatibility :).

Since we're looking at the menu bar, don't forget to take a look at the Field menu:

There are only two functions here, but they can be very useful! Especially the first one - "Replace". It allows you to quickly automatic mode replace values ​​in the entire column of the specified field, or specific words and symbols throughout the database!

The "Calculate" function is an analogue of Excel's auto-calculation formulas and gives us the opportunity to perform such mathematical and statistical operations as finding the autosum of a field, calculating the arithmetic mean, as well as the maxima and minima of values. Naturally, to perform calculations, field types must be numeric (N, F, I, O, B).

The last feature, which is not so obvious but can be useful, is the built-in hex editor:

It allows you to edit the data of any cell. To do this, just select the content that you want to change and select the last item in the context menu - "Open in hex". Everything - you can edit and save or immediately print the result!

Advantages and disadvantages of the program

• portability and small size;
• support for almost all types of DBF files;
• the ability to create databases from scratch;
• support for SQL queries;
• built-in system for searching, filtering and editing data.

• does not allow to specify more than one mask in the filter;
• there is no undo function.

conclusions

The Sdbf program, with its modest size and system requirements allows you to do with DBF databases, if not everything, then very, very much ... And the implementation of support for SQL queries in general allows you to take the work of editing the database to a new level! With their help, you can easily compensate for many shortcomings in the work through the graphical interface.

The biggest disappointment, in my opinion, was the absence of the most trivial function “Undo last action” in the world of “CTRL + Z”: (The most annoying thing is that due to oversight or ignorance, the user can, for example, accidentally apply autocorrect throughout the field, and it will be impossible to return the data :(

For sim it can be stated that the program in functional plan- more than successful, but before working with it, always follow the ancient admin rule - CREATE BACKUPS! And you will be happy :)

P.S. It is allowed to freely copy and quote this article, provided that an open active link to the source is indicated and the authorship of Ruslan Tertyshny is preserved.