Download program for opening DBF files. Opening DBF files in Microsoft Excel

DBF extension is divided into two main categories:

• DBF format (full. databased Intelligence) It is universally applied as a database file in most software applications. This extension is efficiently used as a typical method for storing and transmitting data as database management systems (DBMS), spreadsheets, etc.

For quite a long time (starting in 1980), this information presentation format (known as DBASE) was one of the most popular for DBMS of microcomputers and related software and technical equipment, including Apple, Unix and IBM PC.

The structure of the standard DBF file is based on a spreadsheet containing a certain number of fixed-length data fields, heading and actual records. The first field is a set of structured data to remove record information (asterisk symbol). It is noteworthy that after deleting one or another recording, it can be restored or already removed permanently.

• DBF Extension, which is the file table view of the Oracle database. As an object-relational DBMS, this format is universal for its application and can be equally efficiently used both on the basis of Windows and UNIX. The data in such a DBF file is stored as "tabular spaces" created by integrated Oracle Create / Alter TableSpace commands.

This format has many different performances and modifications, sometimes incompatible with each other. For example, DBF, the developer of which is ESRI, is far from the standard representation of the DBMS and is a set of spatial data in the geographic information system.
Thus, the Unified Standard (technology) of the representation of the DBF format is absent. This creates the user a certain difficulty in opening and editing the file. Sometimes in a set with DBF extension there is a file that does not work autonomously, is auxiliary and opens only together with DBF.

Programs for opening DBF files

Depending on the execution and field of its practical application, the DBF extension can be generated and edited by the following software applications:

• in Windows used dBase, Microsoft Access, Microsoft Excel, Microsoft Visual FoxPro, Microsoft Works, Corel Quattro Pro, Apache OpenOffice, HiBase Group DBF Viewer, Astersoft DBF Manager, DBF Viewer Plus, DBFShow, DBF Navigator, WinDBFView, Sage ACT, CGF Shop Data Management Center, OpenOffice.org Calc, ArcGis, Arago, Abacuslaw, Ca-Dbfast, Wordtech, Alpha Five, Novabackup, The Network Diary, Flare, Acdsee;
• planamesa Neooffice, Apache OpenOffice, OpenOffice.org Calc can be used in the MAC OS;
• in Linux: Apache OpenOffice, MultiSoft Flagship.

If an error occurs when you open the DBF expansion, the reasons may be as follows:

• damaged or infected file;
• the file is not associated with the OS registry (the incorrect application is selected for playback or the installation of a particular plugin is installed);
• insufficient device resources or OS;
• damaged or outdated drivers.

DBF Conversion to Other Formats

In each concrete case Structure and scope practical use DBF extensions are unique. For the format conversion, it is precisely the software product with which generation was made.

However, the most popular way to broadcast the file is considered to convert DBF B. MDB - electronic table view format Microsoft Access.. Possessing a fairly powerful integrated converter, Access can broadcast data with almost lossless and damage.

Conversion of DBF extensions to other formats is practically not practiced.

Why exactly DBF and what is his advantages?

DBF Extension is one of the most popular and demanded formats for storing and transferring data in the form of database management systems (DBMS), spreadsheets I.T.D.

This file may have a large variety of various versions and modifications, sometimes incompatible with each other.

For high-quality processing and editing format, it is strictly recommended to use software applicationWith which the generation of the file was generated.

Programs for working with DBF files.

↓ New in the category "Work with DBF":

Free
Editor DBF 1.75.1 is a fairly powerful viewer and editor for DBF files, which will provide the ability to perform a large number of operations with databases. The DBF Editor application provides for the ability to view and edit DBF files in DBASE III-IV, Visual FoxPro, FoxPro and Clipper formats.

Free
SCAN DBF 1.6 is an application for repair or restoring damaged DBF files. The Scan DBF application will help restore damaged files when the computer or power failure fails when the end or the DBF file header itself is damaged.

Free
Reportizer 3.7.1.629 is a tool for making and print reports executed by databases. The Reportizer application will help ease to create, print and change reports, and managing report collections.

Free
DBREDIT 1.25 is the editor of tables for bases dBF data. DBREDIT editor works with flat tables without using drivers and access systems.

Free
DBF2ORA 1.0 is an application for importing from DBF data tables in Oracle, as well as the ability to save the settings for imports. The DBF2ORA application also has the ability to process files before importing imports.

Free
DBF Work 3.0.0.1 is a program on viewing, editing and exporting DBF files format. The DBF Work program has the ability to export data in 14 formats (PDF, Excel, Word, HTML and other).

Free
DBF View 2.79 is free, compact and convenient program on working with DBF files. The DBF View program works without installing, as well as without additional libraries or drivers.

Free
DBF Desktop 1.0.0.0 (BUILD 2600) is a multifunctional editor for DBF files (databases). The DBF Desktop program provides for the ability to create new DBF tables, package them, change the structure (order of fields) and create indexes with expressions.

Free
DBF Data Import for Oracle 1.4 is professional tool By importing or prepare for importing DBF files from the XBASE programming language category (Visual FoxPro, Clipper, Flagship, FoxPro, Foxbase, Dbaseii +, Dbasev and Dbaseiv) to the Oracle database.

Free
Check and Repair DBF 1.4.0.2 is a convenient application for diagnosing and restoring damaged files DBF from Xbase programming language family (Foxbase, Flagship, FoxPro, Dbasev, Dbaseiii +, Clipper, Dbaseiv, Visual FoxPro). The Check and Repair DBF application has the ability to carry out a detailed analysis, as well as the diagnostics of the file structure.

Free universal DBF editor that allows you to open existing and create new databases. It has very small sizes, it can start from a flash drive and has many advanced tools to work with DBF files, among which there are even support for SQL queries!

Gallery Screenshotovot

Usually on the site we light the programs that will be interested in a wide range of readers, but today the case is not quite ordinary :). I once worked as a "computer specialist" in several state offices and there often had to deal with various FoxPro database programs ...

The main problem of all these applications was that a simple user could easily damage the database so that it was impossible to open it later staffing, Therefore, I had to be perverted to return it to life (which was not always done, given the "abilities" of "wild yuzvers" :)).

And now, a few years later, as I do not work there, we sent a new one to the post office free program To edit the DBF databases, which has an uncomplicated name - SDBF.. About her and talk :)

Comparison with a paid analogue

SDBF, despite its portability (can work with a flash drive!) And small size, is a fairly advanced database editor that allows you to create, edit and export any DBF format databases, starting with the XBASEIII specification, and ending with modern XvisualFoxPro! Compare SDBF functional, with the possibilities of one of the most advanced editors of this sense DBF Commander Professional:

From the above placle, we see that programs are slightly different in functionality, but SDBF, firstly, is portable (which is usually important, since each computer deeds master prefers to wear a set of necessary programs on the flash drive), and secondly, is completely free!

First launch SDBF.

To start the program, it is enough to unpack from the downloaded archive to any place and open the exe file received. Before us will appear an empty window of the following type:

Drag & Drop, alas, not supported, so to start work, we will need to call the "File" menu and there already choose one of the two available actions: "Create" a new base or "open" existing. Open the existing database:

We will open the contents of the selected database in the form of a table. In the "zero" line displays the names of the fields, and starting with the first - the content itself. Under the content below there is a toolbar and status string.

In the latter, quite a lot of useful service information is displayed, including the number of entries in the database, encoding, creation date and automatically defined format. The SDBF formats do not support only early 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 Filter Tools

The SDBF program allows you to directly edit any cell of an open database, however, the desired cells still need to find ... If the base is small and simple, then this can be done quite quickly and manually. However, if there are several dozen records, or even hundreds, then it can be pretty difficult to look for.

But this is not such a problem, because in SDBF there are several tools at once, allowing unnecessary data to cut out and display only what you need!

These tools are on the bottom of the toolbar. Here at first goes 8 navigation buttonswhich allow you to move on the basis (arrows), add / delete records, as well as confirm or cancel changes. The functions you need begin with the ninth button - "Search":

When you activate the button, a small window appears with a search form. We need to specify the text you want to find and choose from the drop-down list the field for which the search will be made. Now click the "Find Next" button and the program will automatically highlight the string below for the current release in which there is a desired text. The re-pressing of the button will allocate the line below from the current, in which there are the same items, etc.

Sometimes in databases there is a non-standard cell formatting: unnecessary spaces, tabs and other characters that are visually displayed, but affect the result of the search result. If you encounter such a case, then for normal operation, it will be enough for you to read the box "Taking into account the format" in the lower central part of the search box and the desired rows will be displayed.

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

To use filtering, we need to first make a request and enter it into a specially designated field (immediately outside the button in the central part of the toolbar). The principle of drawing up request is simple, but not entirely obvious. We first need to enter the field name for which you need to filter the database table, and then equate the filter value to a specific text that we need to find all the lines.

The value take into single quotes, after which we click the "Filter" button (it becomes clamped) and we obtain the table containing the data only with the values \u200b\u200bdefined to us in the specified fields (in the example, we filtered all rows with the "USA" value in the "COUNTRY" field (The value indication register does not have the value)). You can simply return the table to the original form by repeatedly pressing the "Filter" button (it becomes again pressed).

The filtering field may contain the simplest conditions "and" (to clarify the request for several fields) and "OR" (for an alternative sample of data from different fields). Unfortunately, SDBF does not support exclusive requests (such as NOT), but this restriction we can bypass in another way, which will be discussed just below.

By the way, so as not to enter a manual filtering request, you can use the following trick: Highlight any entry in the field for which you will filter and press the "Alt + F" key combination (not F4 :))). The request will be automatically formed, and in the value will stand the "*" sign, which is a search mask and corresponds to any number of any characters.

Alas, this is the only type of masks that can be used in SDBF and, which is even sadder, one request can contain only one mask: (Therefore, if you need to filter the same field in several parameters, you will have to use the "and" operator (Fast formation of a request by pressing "Ctrl + Alt + F") or "OR" ("SHIFT + ALT + F").

Execute SQL queries to database tables

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

With the help of such requests to SDBF, we can:

1. Dynamically format our table, creating a sample only by defined desired fields (SELECT and SELECT TOP statements);
2. Copy data from one database to another (INSERT FROM and INSERT INTO);
3. Change and delete content specific lines (Update and Delete, respectively);
4. Group parallel requests (UNION);
5. Form summary tables (Pivot).

To start working with the requests, we need to press the "SQL query" button at the right end of the toolbar. However, the result of such actions will be somewhat discouraging: the contents of the just edited base data will disappearAnd one more empty window with two fields will appear on top of the working window (at the top - the data output field, and at the bottom of the input).

It is not necessary to scare :). You just need to immediately enter the desired SQL query in the lower field with the name of the desired database. If you do not remember this name, you can activate the SDBF side panel (pressing on the gray vertical strip on the right), on which all the databases that you have opened in the form of a list are displayed:

It is also desirable to memorize hotkeys to speed up the work, which can be viewed by calling the F1 key pressing. There are only three of them, but they allow you to significantly speed up the process of creating the right requests.

So, a combination of "Ctrl + Space" - display a pop-up window with a list of available database names (so as not to look into the sidebar), "Ctrl + F" - will display a list of functions for the current operator, and "Ctrl + Enter" will start the query execution process . In addition, if you click on the input field with the right mouse button (call context menu) We will receive a list of supported SDBF operators.

Let's go back to our previous screenshot and look at the simplest requestwhich is made there. It is based on the "SELECT" operator, which means that the sample returns us. The sampling parameter is "*", which means the output of any data, however, we could specify there through the comma of the names of any fields of the database table.

The sample that we looked above is the simplest, however, SDBF allows you to perform queries and more comprehensive. In the following screenshot, we will see a sample, a dynamically formed table consisting of fields that contain customer names, a city in which those live and the country. Moreover, customer filtering goes precisely by the country of residence (U.S.A) and the results are displayed in alphabetical order:

If you disassemble this request, then we will see the method of sampling on the fields indicated by the comma after the SELECT operator. Next, all the same specifying the name of the database, but now the request does not end.

The next step will be the enumeration of the functions of the main operator, which will have to be executed as a result of the processing of the request. Here are two of them.

The first - "WHERE" has similarity with the filter discussed by us earlier, and performs a similar action - allows you to select only those records that match the condition.

The second function - "Order by" is responsible for sorting the results obtained according to one of the fields (in this case, by the field with the client name - "Name") in the alphabetical (parameter "ASC") or inverted ("DESC") order.

Naturally, the example above is also quite primitive, but it displays general essence Creation and processing SQL queries. If you want to know 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\u003dsql&s\u003d0.

By the way, the SDBF plus is the ability to export the resulting table as a result of a query, as a new database or in HTML, RTF, or a CSV file! To do this, it suffices to call the context menu of the table display fields and select the appropriate item.

Additional features from the menu row

With the main capabilities of SDBF, we figured out, but it all does not end. A whole range of useful and even unique features in themselves the line of the menu, the one that we used to open a database :) So, many useful features (which sometimes allow you to do without SQL queries) in the "Table" menu:

Among other "utmost" such as changing coding and merging databases at the very bottom, we can find the item "Change the structure". This item causes an additional window in which we can completely change all the fields of the open table, add new ones, or delete more unnecessary partitions (the same window opens when you create a database from zero).

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

The only thing to remember when editing (and especially creating) the bases is that for each type of base there are sets of field types and they are often (if not to take into account the main N, C, D) differ. For example, in Xclipper databases, there is no support for the fields with pictures (p, b), and Xbase up to the seventh version do not support auto-closet fields (+). That is, you should always remember compatibility :).

Since we consider the menu bar, do not forget to look into the "Field" menu:

There are only two functions here, but they are very helpful! Especially the first - "replace". It allows you to quickly in automatic mode Replace the values \u200b\u200bin the entire column of the specified field, or specific words and characters throughout the database!

The function "Calculate" is an analogue of Excel Avto-Speech formulas and gives us the opportunity to produce such mathematical and statistical operations as the foundation of the fields of the field, calculating the average arithmetic, as well as maxima and minima of values. Naturally, to perform calculations, the field types must be numeric (N, F, I, O, B).

The last function that is not so obvious, but it can be useful is the built-in Hex editor:

It allows you to edit any cell data. To do this, it is enough to select the contents that you want to change and select the last item in the context menu - "open in hex". All - you can edit and save or immediately print the result!

Advantages and disadvantages of the program

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

• does not allow you to set more than one mask in the filter;
• no cancellation function.

findings

SDBF program with its modest sizes and system requirements Allows you to do with DBF databases. new level! With their help, you can easily compensate for many shortcomings through the graphical interface.

The most big disappointment, in my opinion, was the absence of the most trivial function "Cancel the last action" in the world "Ctrl + Z": (the most offensive thing is that the user may, for example, accidentally apply the auto transaction throughout the field, and return The data will already be impossible: (

For the SIM one can stating that the program in the functional plan is more than successful, but before work with it, always follow the ancient administrative rule - create backups! And you will be happy :)

P.S. It is allowed to freely copy and quote this article, provided you specify open active Link To the source and preservation of the authorship of Ruslana Toruschny.

DBF Viewer 2000 ® - App for viewing and editing DBF all types - Clipper, Dbase, FoxPro, Visual Foxpro, Visual Dbase.

The program performs various actions: requests, deleting duplicates or export to various formats - faster than you expect!

DBF editor dynamically creates visual forms based on the DBF file structure for editing and queries. The program also allows you to view and edit the Memo fields of the following formats: DBASE III, DBASE IV, FOXPRO, VFP and DBASE LEVEL 7.

The fullness program supports the use of a command line for the following: Import, Export, Deleting Duplicate Records or Replacing Data in DBF files. Works independently of various DBMS - all you need to view and edit a DBF file to install the application!

Why DBF Viewer 2000
unique?

Simple and intuitive interface

The application interface is quite simple and convenient, allows you to save a lot of time with everyday work.

Convenient modification of the DBF file structure in DBF Viewer 2000

You can add, delete, rename, change the order of fields and optimize the structure of DBF files.

Import data from various formats with DBF Viewer 2000

DBF Viewer 2000 Allows you to import data from the following formats: TXT, CSV, Excel (XLS, XLSX), DBF and PARADOX. Import data can be performed with preview or from a command line.

DBF Viewer 2000 offers extended export opportunities

The application allows you to export DBF files in Excel (XLS, XLSX), CSV, TXT, SQL, SDF, XML, HTML, PRG, and MS SQL, MySQL, Oracle, PostgreSQL scripts.

DBF Viewer 2000 helps remove duplicates

Removing duplicate records is easy as 1-2-3.

Works on all platforms

DBF Viewer 2000 starts at all windows versions from 95 to XP, Vista, 7/8/10 and Server Editions (32/64-bit)

One of the most popular storage formats of structured data is DBF. This format is distinguished by universality, that is, it is supported by many DBMS systems and other programs. It is used not only as a data storage element, but also as a means for exchanging them between applications. Therefore, the question of opening files with this extension in the Excel table processor becomes quite relevant.

You should know that there are several modifications in the DBF format:

• dBASE II;
• dBASE III;
• dBASE IV;
• FoxPro et al.

The type of document also affects the correctness of its opening programs. But it should be noted that Excel supports correct operation with almost all types of DBF files.

It should be said that in most cases Excel copes with the opening this format quite successful, that is, opens this document as well as this program Opened, for example, its "native" format XLS. But save files in DBF format standard means Excel stopped after Excel 2007 version. However, this is the topic for a separate lesson.

Method 1: Start through the window opening window

One of the easiest and intuitive options for opening documents with the DBF extension in Excel is to start them through the window opening window.

Method 2: Double-click Opening

Also a popular way to open documents is the launch by double-clicking with the left mouse button along the corresponding file. But the fact is that by default, if specifically not to prescribe system settingsThe Excel program is not related to the extension of DBF. Therefore, without additional manipulations, this way does not work out. Let's see how it can be done.

1. So, we make a double click of the left mouse button along the DBF format file, which we wish to open.



2. If on this computer In the system settings, the DBF format is not associated with any program, the window will start, which will not be reported that the file could not be opened. It will offer options for action:
   • Search for conformity on the Internet;
   • Select the program from the list of installed programs.

   As it is understood that tabular processor Microsoft Excel is already installed, we rearrange the switch to the second position and click on the key Ok At the bottom of the window.

   

   If this extension is already associated with another program, but we want to run it in Excel, then we do somewhat differently. Click on the name of the document right-click. The context menu is launched. Choose a position in it "To open with". Another list opens. If there is a name in it "Microsoft Excel", then click on it, if you do not find such a name, then go through item "Choose a program ...".

   

   There is another option. Click on the name of the document right-click. In the list that opens after the last action, choose a position "Properties".

   

   In the running window "Properties" Move into the tab "Are common"If the launch occurred in some other tab. Near the parameter "Application" Click on the button "Change ...".



3. When you select any of the three options, the File opening window is started. Again, if in the list of recommended programs at the top of the window there is a name "Microsoft Excel"then click on it, and in the opposite case we press the button "Overview…" At the bottom of the window.



4. In the case of the last action in the program location directory on the computer opens a window "To open with…" In the form of a conductor. It needs to go to the folder that contains the Excel program launch file. The exact address of the path to this folder depends on the version of Excel, which you have installed, or rather from the package version Microsoft Office.. The common path pattern will look like this:

   C: \\ Program Files \\ Microsoft Office \\ Office #

   Instead of symbol «#» It is required to substitute the number of your office product. So for Excel 2010 it will be a number "14"And the exact path to the folder will look like this:

   C: \\ Program Files \\ Microsoft Office \\ Office14

   For Excel 2007 number will "12"For Excel 2013 - "15", for Excel 2016 - "16".

   So, we move to the above directory and looking for a file with the name "Excel.exe". If you do not start the display of extensions in the system, then its name will look just like "Excel". We allocate this name and click on the button. "Open".



5. After that, we automatically be transferred again to the program selection window. This time the name "Microsoft Office" Here will definitely be displayed. If the user wants to this application Always by default opened DBF documents with a double click of the mouse over them, then you need to make sure that about the parameter "Use the selected program for all files of this type" There is a tick. If you are planning only a single open DBF document in Excel, and then you are going to open this type of files in another program, then, on the contrary, this check mark should be removed. After all the specified settings are made, click on the button Ok.



6. After that, the DBF document will be launched in excel program, And if the user set a tick in the appropriate place in the program selection window, now the files of this extension will be opened in Excel automatically after double click on them with the left mouse button.

As you can see, open DBF files in Excel is quite simple. But, unfortunately, many novice users are confused and do not know how to do it. For example, they do not guess to set the appropriate format in the opening window of the document through the EXEL interface. Even greater difficulty for some users is the opening of DBF documents. double-click left mouse buttons because for this you need to change some system Installations through the program selection window.