How to zrobiti the dbf file. Creating a dbf file from excel - VBA. Viewing the DBF file

Golovna / Optimization of work

Bezkoshtovny universal DBF editor that allows you to create new data bases. May even be small, you can run from a flash drive and if you can put a lot of tools for working with DBF files, among them you can get a SQL feed!

Screenshots.

Sound on the site of our visvitlyuyemo program, as it will be a clique to a wide number of readers, but today there are no crossovers :). I used to work as such a "computer specialist" at several state-owned offices and there I often had to deal with different programs that work on the basis of FoxPro.

The main problem of all these additions was those that a simple short-lived person could easily close the database in such a way that it was not possible to be later opened by regular employees, he had to twist around in order to turn її to life (which did not always come out of looking at the “rear” yuzveriv") :)).

First axis, after a few years, as I no longer work there, they sent us a mail to add a new cost-free program for editing DBF-databases, so I can simply name it. Sdbf. Let's talk about her :)

Comparison with paid analogue

Sdbf, regardless of its portability (maybe use a flash drive!) And a little expansion, do it with a database editor that allows you to create, edit and export whether it’s a basic DBF format, start with the xBaseIII specifications, and finish with the current xVisualPro! The functionality of Sdbf is similar, with the capabilities of one of the simplest editors of this DBF Commander Professional:

We’ve added more signs to my bachimo, that the programs are slightly concerned about the functionality, but Sdbf, first, is portable (it’s important to note that the skin of computer information is important for the master to carry the necessary programs on a flash drive more quickly), and friend, I will be without cost!

First run of Sdbf

To run the program її it is enough to unpack the archive in any place and open the EXE file. Before us appear empty of an offensive sight:

Drag & Drop, unfortunately, is not supported, so for the beginning of the work we need to click on the "File" menu and there already select one of the two available ones: "Create" a new database or "Vidkriti" I know. Vіdkriєmo іsnuyuchu base:

We see before us the selected data base as a table. At the “zero” row, the names of fields are displayed, and starting from the first row, he himself. At the bottom there is a toolbar and a status row.

In the rest, you will be asked to complete a lot of basic service information, including a number of entries in the database, coding, the date of creation, and an automatically assigned format. 3 Sdbf formats do not support earlier versions of xBase (I and II) and allow you to create DBF files of newer types:

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

Tools to search and filter data

The Sdbf program allows you to edit without intermediary whether the commissar has entered the data base, however, you still need to know the komirki ... Since the database is small and simple, then you can do it manually. However, if you record a few dozens, or even a hundred, then you can still do it well.

But it’s not the same problem, Sdbf’s shards are just a few tools that allow you to submit data and imagine less than what is needed!

The number of tools is stashed on the lower panel of the tools. There are 8 navigation buttons in a row, which allow you to move around the base (arrows), add / change entries, and also confirm or change changes. The necessary functions start from the ninth button - "Search":

When the button is activated, we see a small one at the end with the form of a joke. We need to indicate the text that we need to know and select the field from the list, according to which the search will be made. Now the “Find Distance” button is pressed and the program automatically sees the row that follows the in-line vision, in which case the text that is joking. Pressing the button again, see the row below the flow line, in which case you can see data, etc.

Sometimes in the databases there is a non-standard formatting of the middle: enter the gaps, tabs and other characters that are not visually displayed, but add a hint to the result. If you are stuck with such a slip, then for a normal robotic function, you will have enough to take the ensign “For the improved format” from the lower central part of the window to look for those rows that are joking around, to begin to look up.

The function is randomly useful, if it is necessary to know the single entry of specific data. Ale trapleyayutsya vpadki, if it would be easier to see the sprat of rows, as if to avenge the same information. In this case, another function will help us (the button to follow the search button) - "Filter":

To set up filtering, we need to first correctly add the request and enter it in a specially entered field (right behind the button in the central part of the toolbar). The principle of folding the bill is simple, but not obvious. We need to start by entering the name of the field, after which we need to filter the data base table, and then we will equate the filter value to a specific text, so that we need to know all the rows.

The values ​​are taken in a single foot, after which the “Filter” button itself is embossed (it becomes squeezed) and we take the table, which will avenge the data only with the values ​​\u200b\u200bassigned to us in the indicated fields (in the butts, all rows with the values ​​\u200b\u200bof “U.S.A” in the field were filtered ”(Register of the entry can not name the value)). You can rotate the table to the correct view by simply pressing the Filter button again (it will become redundant).

The filtering field can be as simple as "and" (for specifying the number of fields) and "or" (for an alternative selection of data from different fields). Unfortunately, Sdbf does not accept turn-only requests (such as “not”), but it can be done in another way, which can go a little lower.

Before speaking, if you don’t manually enter the filtering request, you can quickly use the next trick: see whether there is a record in the field, after which you filter and press the Alt + F keys (but not F4 :))). The request will be automatically formed, and in the value there is a sign “*”, which is a mask for a joke that shows whether there are any number of characters.

Unfortunately, the only type of masks that can be wicked in Sdbf and, even more summarily, one can only quench one mask: (. Therefore, as you need to filter the same field for decal parameters, you will have to win the “and” operator (Shvidke shaping the press "CTRL + ALT + F") or "or" ("SHIFT + ALT + F").

Winning SQL queries to database tables

Poshuk that filtering - tse, bezperechno, good, prote do not start manually. If the number of records is large, we can easily use it for the respect we need to give us an hour to analyze the tables. However, for the most part, Sdbf has an external function - a support for SQL queries!

For the help of such requests from Sdbf, we can:

  1. Dynamically format our table, creating a selection only after the required fields (SELECT and SELECT TOP statements);
  2. Copy data from one base to another (INSERT FROM and INSERT INTO);
  3. Change and see in the same rows (UPDATE and DELETE, obviously);
  4. Group parallel drinking (UNION);
  5. Form the links of the tables (PIVOT).

For the beginning of the work with requests, we need to press the “SQL-request” button at the right end of the toolbar. However, the result of such a task will be worthless: instead of a randomly edited data base, data will disappear, and on top of the working window, another empty one will appear at the end with two fields (in the mountains - the field of data viewing, and below - the introduction).

Lykatisya not varto :). You just need to immediately enter the required SQL query in the bottom field from the specified name of the required data base. If you don’t remember your name, you can activate the Sdbf front panel (I’ll press on the right-handed vertical socket), all the bases appear on the list that you see, as you saw earlier.

Also, to speed up the work, it is necessary to remember the hot keys, which you can look over, calling out how to press the F1 key. Less than three, but they allow you to significantly speed up the process of making the right drinks.

So, CTRL+Problem - display the merging window with the list of available database names (so that it doesn't appear in the web panel), CTRL+F - display the list of functions for the streaming operator, and CTRL+Enter start the process of retrieval. In addition, if you click on the input field with the right mouse button (click on the context menu), then we will take a list of operators that are supported by Sdbf.

Let's turn to our front screenshot and marvel at the simplest request, which is stored there. Win is based on the SELECT statement, which means it turns the choice to us. As the selection parameter is set to "*", which means the display of any data, the prote mi could enter there through whom the names of any fields in the database tables.

Vibirka, as we have seen more, the simplest, prote Sdbf allows you to win more and more. On the next screenshot, we see a selection, a dynamically formed table, which is added up from watering, so that the names of clients, places, children live and live in the country. Moreover, the filtering of clients is the same by country of residence (U.S.A) and the results are displayed in alphabetical order:

As for the choice of the query, we would like to guess the way I chose the fields, we will indicate through whom after the SELECT statement. They gave all those same instructions to the name of the base of the data, but now the request does not end on what.

Coming soon, the functions of the main operator will be redistributed, as the responsibilities will appear as a result of the processing of the request. Here are two.

Persha - “where” is similar to the filter, we will look at it earlier, and vikonu is similar to the day - allowing you to select those records, as if they were mindful.

Another function - "order by" sorts out the results by one of the fields (for this sort by the field with the client's name - "NAME") in alphabetical (parameter "asc") or inverted ("desc") order.

It is obvious that the aims of the butt can also be done primitively, but the main thing is the essence of the creation of SQL-requests. If you want to learn more about them, please read the manuals: http://dimonchik.com/insert.html or https://www.sql.ru/articles/articles.aspx?g=SQL&s=0 .

By the way, plus Sdbf є mozhlivіst eksportuvati otrimana as a result will feed the table as a new database or in HTML, RTF or CSV-file! For which it is enough to click the context menu of the field to display tables and select the appropriate item.

Added functions of the menu bar

With the main possibilities of Sdbf, we have dealt with you, but everything will not end. A whole series of brown and create unique functions to have a menu row, the very one that we have chosen for the data base display :) So, a lot of brown possibilities (which sometimes allow you to do without SQL queries) can be in the "Table" menu:

Among the other "korisniki" type of change coding and data bases at the very bottom, we can know the item "Change the structure". This item needs to be added at the end, in which case we can change all the fields in the crit table again, add new ones, or add more non-necessary parts (it will always be opened when the data base is created from scratch).

We can change the number of fields, their names, tipi, rozmіri (number of signs in the middle) and accuracy (size - it sounds automatically according to the field type).

The only thing that needs to be remembered when editing (and especially created) bases, so those that for the skin type of base, use their own sets of types of watering and stench often (so do not take the main N, C, D) to respect. For example, xClipper databases don't support image fields (P, B), and xBase doesn't support auto-increment fields (+) until the current version. Tobto it is necessary to keep the memory of summіsnіst :).

While we are looking at the menu row, do not forget to look at the "Field" menu:

There are only two functions here, but the stench is even more brown! Especially persha - "Replace". Vaughn allows you to automatically change the value of the entire column of the specified field in automatic mode, or specific words and symbols for all data bases!

The “Calculate” function is an analogue of Excel's formulas and gives us the ability to carry out such mathematical and statistical operations, as the value of the auto sum of the field, the calculation of the arithmetic mean, as well as the maximum and minimum values. Naturally, for the viconann, the types of fields can be numbered (N, F, I, O, B).

The rest of the function, if it's not obvious, but you can also use the HEX editor:

Vіn allows you to correct the data, be it in the middle. For which it is enough to see in place, which one needs to be changed, and in the context menu, select the remaining item - Enter in hex. That's all - you can edit and save or see the result!

Advantages and shortcomings of the program

  • portability and small size;
  • support for all types of DBF files;
  • the ability to create data bases from scratch;
  • subtrimka of SQL-requests;
  • a system for searching, filtering and editing data has been introduced.
  • do not allow to set more than one mask for the filter;
  • there are no functions to tell.

Visnovki

The Sdbf program, for its modest expansions and system capabilities, allows you to work with DBF databases, even if not all, then even more richly ... And the implementation of SQL support in the beginning allows you to run the robot from editing the database on a new level! With this help, you can easily compensate for a lot of shortfalls in robots through a graphical interface.

The biggest disappointment, in my opinion, was the presence of the most trivial function “Say the rest of the day” at the “CTRL + Z” light: impossible :(

For this, you can state that the program has a functional plan - more low distance, but before working with it, always follow the old admin rule - CREATE BACKUP! I will be happy for you :)

P.S. It is allowed to freely copy and quote this article for the understanding of the inscription of an active message sent to the savings by Ruslan Tertishny.

DBF is an extension of the data collection format that appeared in the 80s of the last century. Formerly, the format was stuck with the dBase family of DBMS. In connection with the popularity and wide extensions of dBase, there have been created anonymous dBase-like software products that took away the xBase name. Irrespective of the important format, wine and dossi dosi widely vikoristovuєtsya. The article discusses ways to work with DBF and "1C: Enterprise".

"1C:Enterprise" for working with files in the DBF format (dBase III version) has a special software object - xBase. Work with this object does not sound difficult.

Respect!

Time to work with DBF files Follow the memory that the file may be satisfied with the exchange 8.3.

Respect!

The xBase object is available on both client and server sides. Slid to think over the client-server interaction under the hour of accomplishment of a specific skin task.

Reading a DBF file

Reading data from a DBF file is carried out for a few of the following steps:

  1. creation of an XBase object;
  2. Open file;
  3. The last enumeration of all rows in the file and reading the field values;
  4. Close the file.
DBP = New XBase; DBP. OpenFile("D:\MyFile.dbf"); // Step 2. Write to the file So far True Cycle // Stage 3. Iterating over the rows in the file Remind me (DBF. NAME); Exactly NOT DBF. Nastupna() Todi // Position on the upcoming record interrupt; KіnetsYakscho; EndCycle; DBP. CloseFile(); // Stage 4. Close the file

You can change the algorithm for iterating over the rows in the file:

So far NOT DBF. AtEnd() Loop Remind (DBF. NAME); DBP. Nastupna(); EndCycle;

Viewing the DBF file

Steps to view the DBF file:

  1. creation of an XBase object;
  2. Specify coding (if you don't specify, then there may be ANSI coding);
  3. Description of fields;
  4. Creation file;
  5. Cycle with additions and completions of rows;
  6. Close the file.

Let's take a look at this process on the example:

DBP = New XBase; // Stage 1. Create an XBase object DBP. Encoding = EncodingXBase. OEM; // Stage 2. Entering the coding DBP. Fields. Add("CODE", "S", 9); // Stage 3. Describing the name of the field type DBP. Fields. Add ("NAME", "S", 40); DBP. Create file("D:\MyFile.dbf"); // Stage 4. Create a file Vibrka = Dovіdniki. Nomenclature. Select(); So far Vibirka. Advance() DBF loop. Append(); // Add row DBP. CODE = Vibration. The code; // Fill in the field value DBP. NAME = Vibrka. name; DBP. Write(); // Write row EndCycle; DBP. CloseFile(); // Step 6. Close the file

When specifying an encoding, the encoding type is set to XBase encoding, which can take two values:

  • ANSI- Windows format;
  • OEM- DOS format.

Adding a new field in the description of the structure may syntax

Add (< Имя>, < Тип>, < Длина>, < Точность>)

The following types are available:

  • "N" - number;
  • "S" - row;
  • "D" - date;
  • "L" - boulevard;
  • "F" - similarly "N" - number.

Dovzhina field є obov'yazkovoy for types of fields "N", "F" and "S".

Work with indexes

In addition to the DBF file, an index file can be added, in which there can be information about one or more of the index. The presence of the index allows you to search for a query, and not just a sequential enumeration of all rows in the file.

The hour of creation of the index file of the following task:

  • Perelik indexes;
  • The way to save the index file (on stage 4 of the expansion).

An example of the creation of an index file:

DBP . index. Append("INDCODE", "CODE"); DBP. CreateFile("D:\MyFile.dbf", "D:\index.cdx");

The procedure for adding a new index may have the syntax:

Add (< Имя>, < Выражение>, <Уникальность>, < Убывание>, < Фильтр >)

For indexing the reading hour for the DBF file, follow:

  • Specify the path to the index file (at stage 2 of the acquisition);
  • Enter current index.

An example of adding a DBF file for an additional index file:

DBP . OpenFile("D:\MyFile.dbf", "D:\index.cdx"); DBP. Current index = DBP. index. INDCODE;

Respect!

When opening a DBF file, the position is taken on the first record of the file. The first entry in the file does not match the first entry in the index. At the link with the cym with the same indexes before it, as a sequence of rows, it is necessary to position on the first row of the index. You can use the Persh method (), for example:

DBP. persha();

For a joke, you can tweet one of two functions:

  • Know (< Ключ>, < Режим >) ;
  • KnowByKey(< Режим >) .

As a result of the work of both functions, the value of the Boolean type is rotated (the record was found from the assigned minds of the number). At the time of a successful search, the current indicator is installed on the found row. As a joke mode, you can twist one of the values:

  • «>=»;
  • «>»;
  • «<=»;
  • «<«.

Let's look at the search for the DBF files on the butts:

DBP = New XBase; DBP. OpenFile("D:\MyFile.dbf", "D:\index.cdx"); // When opening a DBF file, an additional index file is indicated DBP. Current index = DBP. index. INDCODE; // Set thread index // Look for the Know method: Yakscho DBF. Know("000000003" , "=" ) Tell me( + dbf. NAME); Otherwise Tell me("Not found"); KіnetsYakscho; // Search using the KnowByKey method: DBP. Key. CODE="000000002"; Yakscho DBF. KnowByKey("=" ) "Found. Item Name: "+ DBP. name); Otherwise Tell me("Not found"); KіnetsYakscho; DBP. CloseFile();

Viewing records for DBF files

Viewing the record is created using the Vidality () method:

DBP . visuality();

Ale, when victorious, the record is not visible from the file irrevocably, it is assigned a visible icon. When sorting through the rows, the records are skipped. It is necessary to go through the entire file, including the details of the deleted record, it is necessary to recognize the value of the truth of power VіdobrazatiVidalenі xBase object. It is not possible to recognize the values ​​of a record on a remote record using the auxiliary function Record Vidality (). To understand the signs of the remoteness, the method Reveal () is used.

DBP . ShowViewDistant = true; So far NOT DBF. AtEnd() Loop Yakscho DBF. RecordDeleted() Todi DBF. Advance(); KіnetsYakscho; DBP. Nastupna(); EndCycle;

For uninterrupted viewing of marked records, the Squeeze () method is used:

DBP . squeeze();

If it is necessary to delete all records from a file without interruption, you can use the ClearFile() method:

DBP . ClearFile();

DBF bid for ADO help

For working with DBF files, you can use the ADO technology. ADO drivers are included with the stock Windows operating system and do not need to be installed additionally.

Let's take a look at the example code for reading from a DBF file using ADO technology:

ADO = New COMObject("ADODB.Connection"); // Create a COM object ADO. Open( "Provider=Microsoft.Jet.OLEDB.4.0; |Data Source=""D:\""; |Extended Properties=DBASE III"); DB = ADO. Execute("Select * from MyFile"); // Request for all records from the file MyFile.DBF So far DB. EOF = 0 Cycle //Loop with records to the DBF file Alert(DB. Fields("Name" ). value); // Butt of the return to the value of the field DB. MoveNext(); //Go to the next entry EndCycle; ADO. close();

The hovered butt has a connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\;Extended Properties=DBASE III. At this row:

  • Provider - the driver that wins;
  • Data Source - way, de є DBF file. The route is specified exactly to the catalogue. Im'ya file vikoristovuєtsya like im'ya tables in the records;
  • Extended Properties – DBF file extension with language parameter. You can specify file format

Respect!

When reading in the specified way behind the lock, the coding is OEM. In order to change the encoding to ANSI, you need to set the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\xBase\DataCodePage value to "ANSI" in the Windows registry.

Run out of food?
Ask the comments to the article.

how to create a dbf file from an excel with ADO wikis in ADO I got lost ...... I myself have specific information ... 2. creating a dbf file (other options); 3. record; 4. saving; 5. close. for some reason info

what to joke on this topic or ignore it again ..... on the topic of ADO, you can create a better topic ..... more ADO reference

sparingly how to get out

Task code: "Create dbf file from excel"

textual

Program listing

"::: Step 1 - Looks like we're running homeDir=Wscript.ScriptFullName "::: Where to find our file k=Instrrev(homeDir,"\") "::: Looks like "\" ends homeDir=left ( homeDir,(k-1)) "::: Net - clean directory name "::: Step 2 - Create an ADO-Create that empty set of records Set Conn = CreateObject("ADODB.Connection") Set RS = CreateObject(" ADODB.Recordset") DSNName = "DRIVER=Microsoft dBase Driver (*.dbf);DBQ=" DSNName = DSNName & HomeDir "::: Step 3 - Conn.Open DSNName "::: Step 4 - ready SQL statement for creating tables SQL="create table Testtable (N1 Float, N2 Float)" "::: Step 5 - do it RS.Open sql, Conn, 3,3 "::: Step 6 - Add 100 records into 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 - subtotal... SQL="Select sum(N1),sum(N2) from Testtable" Rs.Close SQL="Drop tabl e Testtable" RS.Open sql,Conn,3 ,3 MsgBox "Table has been deleted!"

DBF is the most popular format for storing and exchanging data between different programs, and for us in front of add-ons, as a way to maintain data bases and spreadsheets. Wanting to win and becoming old, but continue to be in demand from other spheres. For example, they are actively developing accounting programs with it, and controlling and state authorities receive a significant part of the feedback from this format.

But, unfortunately, Excel is starting from the version of Excel 2007, having added a new subset of the designated format. Now, in your program, you can no longer look at the DBF file, and you can no longer save data from the extensions assigned to the program tool. Luckily, it's still possible to convert data from the Excel program in the format we need. Let's see how a visconati can be.

In Excel 2003 and earlier versions of the program, it was possible to save data in DBF (dBase) format using the standard way. For whom it is necessary to click on the item "File" at the horizontal menu of the program, and then at the list select the position "Save the Yak...". For the saver that has started, from the list you need to select the name of the required format and click on the button "Save".

But, unfortunately, starting from the version of Excel 2007, Microsoft's retailers are old-fashioned dBase, and today's Excel formats are too foldable in order to save time and money on the security of the new money. Therefore, in Excel, the ability to read DBF files was lost, but data saving in this format was pinned by the software tools. Tim is no less, he discovers ways to convert data, savings in Excel to DBF for the help of zastosuvannya nadbudov 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 easiest ways to convert data from Excel to DBF is using the WhiteTown Converters Pack for converting objects with various extensions.

Although the procedure for installing this program is simple and intuitively understood, nevertheless, we report on it, showing some nuances.

  1. After that, as you zavantazhili, she launched the installer, it immediately turns up in the end Maistry installations, in which it is recommended to choose the language for the next installation procedure. For zamovchuvannyam there may be that language, as it is installed on your copy of Windows, but if it is installed, you can change it. We won’t be able to work and just emboss on the button "OK".

  2. Next, it starts every other time, in which place is indicated on the system disk, where the utility will be installed. For promotional folder "Program Files" on disk "C". Here it’s better not to change anything and press on the key "Dali".

  3. Let's wake up victoriously, in which you can choose, as if you are directly transformed you want a mother. All available converting components were selected for promotion. But, perhaps, the deacons of the coristuvachi do not want to install their mustache, to the one that the skin utility takes up space on a hard drive. At every time, it is important for us that there should be a check mark on the item "XLS (Excel) to DBF Converter". The installation of other components of the utility package can be chosen by the authorities. After that, as it is broken, do not forget to click on the key "Dali".

  4. The next one is revealed in the window, in which the yarlik is added to the papacy. "Start". For locking the yarlik is called "Whitetown", but you can change your name for the bazhannya. Press on the key "Dali".

  5. Then we start up all the time, where we eat, how to create a shortcut on the work table. If you want, if you want to add the number of submissions, check the box next to the specified parameter, if you don’t want, then you need to know. Let's sweat, like a dream, emboss on the key "Dali".

  6. After that, one more time is revealed in the end. The new one has the basic installation parameters. If you don't want to edit the parameters, then press the key "Back". If everything is good, then click on the button "Install".

  7. The installation procedure starts, the progress is displayed by a dynamic indicator.

  8. Then we will see the information in the English language, de-visit as soon as the drive of the installation package. Press on the key "Dali".

  9. In the rest of the week Maistry installations It appears that the WhiteTown Converters Pack program has been installed successfully. We don't have to press the button anymore "Complete".

  10. After that, a folder under the name will appear on the working table "Whitetown". Vaughn to avenge utility shortcuts for specific conversion directions. Open this folder. We have before us a large number of utilities that can be included in the WhiteTown package with different direct conversions. With any skin, I can directly use a utility for 32-bit and 64-bit Windows operating systems. Open the program with the name "XLS to DBF Converter", which depends on the bitness of your OS.

  11. The XLS to DBF Converter program starts. Yak bachimo, the interface is English, ale wine is intuitively intelligent.

    The tab immediately pops up "Input" ("Introduction"). Won is recognized in order to indicate the object, which is the next to convert. For which embossed on the button "Add" ("Add").

  12. After that, it is standardized at the end of adding the object. It is necessary for a new one to go to the directory where we need an Excel workbook with extensions xls or xlsx. After the object is found, we see its name and emboss on the button "Vidkriti".

  13. Yak Bachimo, after which way to the object was seen by the depositors "Input". Press on the key "next" ("Dali").

  14. After that, we automatically move to a friend's tab "Output" ("Visnovok"). Here it is necessary to indicate in the same directory as the directory itself, there is a ready-made object from the DBF extensions. In order to select the folder for saving the finished DBF file, click on the button "Browse..." ("Look Back"). A small list of two points is shown "Select File" ("Select File") that "Select Folder" ("Select Folder"). In fact, the numbers do not mean the choice of a different view of the navigation windows, so that you can specify the save folder. Robimo choose.

  15. At the first turn, it will be great "Save the Yak...". It will look like folders, so it will already be aware of dBase objects. Let's move on to the directory, de bazhaemo zrobiti zberezhennya. Dali near the field "Im'ya file" vkazuєmo those names, for some reason, schob was the object after the conversion. The second is embossed on the button "Save".

    How will you get the option "Select Folder", should be simplified at the end of the choice of directory. The new one seems to have less folders. We select the folder for saving and press the button "OK".

  16. Yak bachimo, if it be so, from tsikh diy way to the folder for saving the object will be shown at the depositor "Output". To go to the next tab, click on the key "next" ("Dali").

  17. In the rest of the deposit "options" ("Parameters") duzhe richly nalashtuvan, but it’s more for us to cackle "Type of memo fields" ("Memo field type"). Clicking on the field "Auto" ("Auto"). Show a list of dBase types to save the object. This parameter is more important, because not all programs that work with dBase can process all types of objects with these extensions. It is necessary for him to know which type to choose. It is possible to choose from six different types:
    • dBASE III;
    • FoxPro;
    • dBASE IV;
    • Visual FoxPro;
    • >SMT;
    • dBASE Level 7.

    Robimo chooses the type that is needed for stosuvannya in a particular program.

  18. After that, as selected, you can proceed to the non-intermediate conversion procedure. For which embossed on the button "Start" ("Start").

  19. The conversion procedure starts. If in the book of Excel there is a sprat of arches with data, then for the skin of them a small DBF file will be created. About the completion of the conversion process, check the green progress indicator. After that, yak vin did until the end of the field, embossed on the button Finish ("Finish").

The finished document will be folded with the director, as indicated by the depositor "Output".

The only shortfall in the way of downloading the WhiteTown Converters Pack is that it will be possible to carry out no more than 30 conversion procedures without cost, and then we will have to get a license.

Method 2: XlsToDBF superbud

It is possible to convert an Excel book to dBase without intermediary through the program interface for the help of installing third-party boosters. One of the best and most successful є nadbudova XlsToDBF. Let's look at the algorithm її zastosuvannya.

  1. Since the XlsToDBF.7z archive has been captured from the above-budget one, it will be unpacked from a new object under the name XlsToDBF.xla. If the archives have a 7z extension, then the unpacking can be carried out either with the standard program for the 7-Zip extension, or with the help of another archiver, which supports the work with it.

  2. The next time you start the Excel program, go to the tab "File". Dali moved at the branch "Parameters" through the menu at the left part of the window.

  3. At the end of the parameters, what was said, click on the item "Nadbudovi". Move to the right part of the window. At the very bottom of the yogo, a field has been cut "Management". We change the jumper at the position "Nadbudovi Excel" and click on the button "Go...".

  4. It is not great at the end of the management of nadbudov. Tisnemo in new on the button "Looking back...".

  5. Runs at the end of object opening. We need to go to the directory where we can find XlsToDBF unpacking archives. We go into the folder with the same name and we see the object from the name "XlsToDBF.xla". The second is embossed on the button "OK".

  6. Then we turn around at the end of the management of the nadbuds. Yak bachimo, the list has a name "XLS -> DBF". Tse i є our nadbudova. There can be a check mark for it. If the tick is checked every day, then we put її, and then we emboss on the button "OK".

  7. Otzhe, nadbudov installed. Now you can open an Excel document, it is necessary to convert data into dBase, or simply type them into Arkush, as a document of no creations yet.

  8. Now it will be necessary for us to work out some manipulations with the data in order to prepare them for conversion. Nasampered, add two rows above the heading of the table. Blame it on the Arkush and name on the vertical coordinate bar "one"і "2".

    At the top leviy komіrtsі enter the name, as we want to assign to the created DBF file. It is made up of two parts: well-named expansion. Less than Latin is allowed. An example of such a name - "UCHASTOK.DBF".

  9. At the first center, the right-handed type of name must be given a code. There are two options for coding from zastosuvannyam given overhead: CP866і CP1251. Yakshcho oseredok B2 empty or in it it is installed whether it is significant, vіdmіnne vіd "CP866", then there is a coding for the lock CP1251. We put those coding, as it is important for the needs, otherwise the field is left empty.

  10. Let's move on to the next row. On the right, in what is in the dBase structure of the skin stovpets, which is called a field, there can be a powerful type of data. Establish the following meanings:
    • N(Numeric) - numbers;
    • L(Logical) - logical;
    • D(Date) – date;
    • C(Character) - row.

    Besides, at the rank and file ( cnnn) and numeric type ( Nnn) after the name of the viglyadі literi should indicate the maximum number of characters in the field. In addition, in the numeric type, dozens of characters are included, and the number of digits is also required to be specified after the dots ( Nnn.n).

    Use and other types of data in the dBase format (Memo, General, etc.), but it is not possible to work with them. Please note that Excel 2003 cannot be used with them, if you convert to DBF.

    For our particular type, the first field will be a row width of 100 characters ( C100), and other fields will be numeric 10 characters wide ( N10).

  11. At the advancing row, the names of the fields are roztashovan. Ale rіch to the fact that stench can also be entered in Latin, and not in Cyrillic, like ours. Also, clearings are not allowed near the named fields. Pereimenovuєmo їх vіdpovіdno to tsikh rules.

  12. After that, the preparation of the data will be completed. You can see the entire range of tables on the arc with the cursor from the left mouse button. Let's go to the tab "Rozrobnik". It is turned on for locking, for that, before further manipulations, it is necessary to activate that enable macros. Dali on the lines at the block "The code" click on the icon "Macrosi".

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

  13. Runs at the end of macros. In the field "Im'ya macro" enter the name of our nadbudovi "XlsToDBF" without paws. Your register is not important. Dali click on the button "Vikonati".

  14. The macro in the background mode has a processing. After that, in the same folder, deleting the output Excel file, an object will be generated with the DBF extensions with the same name, as it was given in the middle A1.

Yak Bachimo, the Danish way is significantly folding for the front. In addition, there are also differences between the number of irrigation types and the creation of object types with DBF extensions. Another shortcoming is that the directory of the creation of the dBase object can be recognized only before the conversion procedure by means of a direct move to the folder assigned to the output Excel file. Among the advantages of this method, it is possible to recognize those that on the front view of the front variant of wines are absolutely cost-free and practically all manipulations are carried out without interfacing through the Excel interface.

Method 3: Microsoft Access

Although the new versions of Excel do not have a known way of saving data in the DBF format, the prote version of Microsoft Access has come close to being called standard. On the right, the program is published by the same editor as Excel, and is also included in the Microsoft Office package. Until then, the most secure option, which will not need to be contacted by third-party software vendors. Microsoft Access is specially designed for working with data bases.

  1. In addition, as all the necessary data on Arkush Excel is introduced, in order to convert them to the DBF format, it is necessary to save some money in one of the Excel formats. For this click on the end of the floppy disk at the top left corner of the program.

  2. Vіdkriєtsya vіkno sberezhennia. Let's go to the directory, de bazhaemo, a file of savings. Itself z ієї yogo folders will need to use Microsoft Access. The format of the book can be redeemed for the xlsx promotion, or you can change it to xls. In this case, it is not critical, because all the same we save the file only in order to convert it to DBF. After that, how all the lacing of vikonan, embossed on the button "Save" that closes the Excel window.

  3. We start the Microsoft Access program. Go to the tab "File" yakscho won't show up in other deposits. Tisnemo per menu item "Vidkriti", roztashovaniya at the left part of the window.

  4. View the window of the file. Moving on to the directory, we saved the file in one of the Excel formats. Sob vіn vіdrazivsya vіknі, rearranged by changing the file format in position "Excel Workbook (*.xlsx)" or Microsoft Excel (*.xls), Fallow in that, in which of them the book was saved. Since the name of the file we need appears to be, we can see that it is embossed on the button "Vidkriti".

  5. Vіdchinyaєtsya vіkno "Contact with Spreadsheet". It allows you to transfer data as correctly as possible from an Excel file to Microsoft Access. We need to select an Excel sheet, data from which we choose to import. On the right, in the fact that the information was placed on decal files in the Excel file, then you can import it into Access only OKremoly, apparently, then convert it to other DBF files.

    Also, it is possible to import information of the last ranges on archways. Ale is not needed in our mood. We install a jumper at the position "Leaves" and then we choose that sheet, the stars are chosen to take data. The correctness of the displayed information can be looked over at the lower part of the window. Everything pleases, embossed on the button "Dali".

  6. At the offensive vіknі, like a table to sweep the headings, it is necessary to check the box next to the item "The first row to avenge the headlines". Let's press the button "Dali".

  7. You can change the name of the linked element in the new window's link to the spreadsheet. Let's press the button "Ready".

  8. The next time you see a dialogue window, in which you will be informed about those that the linking of the table with the Excel file is completed. Tisnemo on the button "OK".

  9. At the left part of the program interface, the name of the table will appear, as we gave it in the rest of the week. Double click on the new left mouse button.

  10. The next table will appear at the window. Navigate to the tab "Zovnishni data".

  11. On the page at the block of tools "Export" click on the writing "Dodatkovo". From the list that you see, select the item "dbase file".

  12. Valid for export in DBF format. In the field "Im'ya file" you can specify the place to save the file and that name, as if you were given a lock, for some reason you don’t fit.

    In the field "Format file" choose one of three types in DBF format:

    • dBASE III(for lockdown);
    • dBASE IV;
    • dBASE 5.

    It is necessary to be sure that the current format (higher serial number), then there are more possibilities for processing in new data. That's more than the ability of the file to save all the data of the tables. But at the same time, the lower is the possibility that the program, where you choose to import the DBF file in the future, will be the same with this type.

    After that, as all the settings are set, embossed on the button "OK".

  13. As soon as there was a message about the pardon, try exporting the data, which is another type of DBF format. If everything went well, then it will show up, in which it is confirmed that the export was successful. Tisnemo on the button "Close".

The created file in dBase format will be located in your directory, as specified in the export. Then you can work with it, whether it be manipulations, including the import of yoga into other programs.

However, regardless of the fact that in current versions of Excel it is possible to save files in the DBF format using tools, the procedure can be done with the help of other programs and superbuds. In any case, it should be noted that the most functional way of converting is the same as the WhiteTown Converters Pack. But, unfortunately, a handful of non-koshtovnyh alterations have been fenced for him. Nadbudov's XlsToDBF allows converting absolutely cost-free, but the procedure is too complicated. Until then, the functionality of the second option is smaller than the surroundings.

The "golden mean" is the way to use the Access program. Like Excel is the company Microsoft, you can’t call yoga a third-party addendum. Before that, this option allows you to convert an Excel file in dBase format. If you want a simulacrum of Access, you still have to accept the WhiteTown program.

Choice of editors

© 2022 androidas.ru - All about Android