Questions tagged [dbf]

ISAM database format originally created in dBase but used by many other systems like `Clipper` and `FoxPro` and still widely used for information interchange.

xBase (by software titles) or DBF (by main file extension) is unofficial name for a family of ISAM databases, that started with Ashton-Tate dBase-2 program.

Databases were consisted of tables, each of those consisted of main *.dbf files and a number of satellite files (indices, blobs, etc).

The format was dominant in its time frame and many programs also chosen it as their main format. However they usually extended it in different mutually incompatible ways. It also does not help that main file usually does not contain information which dialect is used and which auxiliary files were created.

This usually is not an issue for one-way import-export operations, but lead for bad consequences on shared read-rite operations (example: two programs that keep indices in different files may end up duplicating the data row and each program would only see their clone).

Main format branches were:

  • Original: Ashton-Tate dBase -> Borland BDE (deprecated)
  • Microsoft: FoxBase -> Visual FoxPro. It also was adopted by Clipper and Clip engines.
  • Microsoft Works and Excel (and probably Access). As of Excel 2003 there was only basic support for most old format versions. None of extensions above were supported.

This format is more or less supported by a myriad of software titles, like Microsoft ODBC driver and SQL Server or like Apache OpenOffice.org and LibreOffice, however compatibility of supported DBF format feature sets between any two programs is rarely predictable.

http://en.wikipedia.org/wiki/DBASE
http://en.wikipedia.org/wiki/XBase

735 questions
24
votes
6 answers

What's the easiest way to read a FoxPro DBF file from Python?

I've got a bunch of FoxPro (VFP9) DBF files on my Ubuntu system, is there a library to open these in Python? I only need to read them, and would preferably have access to the memo fields too. Update: Thanks @cnu, I used Yusdi Santoso's dbf.py and…
Tom
  • 36,698
  • 31
  • 90
  • 98
24
votes
7 answers

Is there any free DBF file converter?

I have only found trial versions of these converters. Does anyone know a free one? Any of the following target formats will do: CSV, MDB, SQL, XLS
Jader Dias
  • 81,082
  • 147
  • 410
  • 611
20
votes
3 answers

What is the best opensource dbf driver for java?

Can anybody please mention the best available opensource odbc:jdbc driver to read / write dbf.? I have a dbf file which I would like to query (select/update) via a web application (Tomcat app). Any help/tips would be appreciative. Thank you.
pinkb
  • 533
  • 2
  • 6
  • 15
20
votes
6 answers

Pandas: transform a dbf Table into a dataframe

I want to read a dbf file of an ArcGIS shapefile and dump it into a pandas dataframe. I am currently using the dbf package. I have apparently been able to load the dbf file as a Table, but have not been able to figure out how to parse it and turn it…
FaCoffee
  • 6,303
  • 19
  • 76
  • 148
17
votes
5 answers

How to import a DBF file in SQL Server

How can you import a foxpro DBF file in SQL Server?
Pop Catalin
  • 57,418
  • 22
  • 86
  • 111
13
votes
2 answers

Get data in a .dbf file using c#

How can I get the data in a .dbf file using c#?? What I want to do is to read the data in each row (same column) to further process them. Thanks.
user1484319
  • 159
  • 1
  • 3
  • 12
11
votes
5 answers

Convert .csv file into .dbf using Python?

How can I convert a .csv file into .dbf file using a python script? I found this piece of code online but I'm not certain how reliable it is. Are there any modules out there that have this functionality?
djq
  • 13,348
  • 42
  • 111
  • 148
10
votes
3 answers

How to create a DBF file from scratch in C#?

I am trying to write a DBF file from scratch in my program. I want to create it, add some columns, and then add data to the columns X amount of times. My program will not need to read it in again, but other programs will. I've looked around for a…
Greg
  • 1,529
  • 3
  • 17
  • 26
10
votes
4 answers

How to go from DBF files to SQL Server 2008?

I have an application that uses DBF files and I need to import them to SQL Server 2008. However, I also need to modify some of the data along the way and some columns will be added to tables while others will be deprecated. So far I'm using DBF ->…
Unknown Coder
  • 6,201
  • 19
  • 73
  • 120
9
votes
3 answers

Python: Fast querying in a big dbf (xbase) file

I have a big DBF file (~700MB). I'd like to select only a few lines from it using a python script. I've seen that dbfpy is a nice module that allows to open this type of database, but for now I haven't found any querying capability. Iterating…
static_rtti
  • 46,349
  • 44
  • 123
  • 180
8
votes
5 answers

How to read/write dBase III files using C#/.NET ODBC or OLE?

I have searched for various techniques on how to read/write dBase III (dbf) files using OLEDB or ODBC with C#/.NET. I have tried almost all of the tecniques posted, but without success. Can someone point me in the right direction? Thanks for your…
JP Richardson
  • 35,950
  • 34
  • 117
  • 150
8
votes
6 answers

How to read and write dbf in a native way?

In Delphi for Win32, how to read and write a dbf file in a native way, without the BDE? I know there are some components available in the web, but I have never used any of them, so I don't know which to choose (if any).
eKek0
  • 21,835
  • 24
  • 87
  • 117
8
votes
4 answers

Create .DBF file from SQL table records

I want to create a .DBF file from SQL table records. Such as if there is a table named CountryMaster in SQL and it has 5 columns: ID int identity(1,1) Name varchar(100) Details varchar(200) Status bit CreatedDate datetime And it has 100 rows. How…
Chirag
  • 286
  • 2
  • 4
  • 26
8
votes
8 answers

How to find the default location in which Oracle DBF files are created?

During the creation of a new Tablespace in Oracle Database, the user has to enter the DBF file name that he (or she) want to use. The DBF file is then created in a specific location. The user may also specify a path in which the DBF file should be…
Michael
  • 1,157
  • 2
  • 11
  • 24
7
votes
2 answers

C# Open DBF file

I'm having a problem opening a DBF file - I need to open it, read everything and process it. I tried several solutions (ODBC/OLEDB), several connection string, but nothing worked so far. The problem is, when I execute the SQL command to get…
Tomáš Bezouška
  • 1,143
  • 1
  • 8
  • 22
1
2 3
48 49