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
-1
votes
1 answer

Saving an Access table as dBASE_IV file (.dbf) in VB.NET

I am making a small application that will read .csv files into a newly generated access table (generated with vb.net), I am filling this database with sql and now I would like to output that table as a .dbf file! I can't find any info on this…
Gutanoth
  • 842
  • 4
  • 18
  • 37
-1
votes
1 answer

\r\n in a string not accepted on database

I create a string variable for an Update SQL command in order to execute this command to a dbf file ( with OleDb). When my SQL Command contain in a string \r\n the SqlCommand is not accepted :( Here is an example of my SQL Command : update ZZAg7eve…
Walter Fabio Simoni
  • 5,331
  • 11
  • 43
  • 73
-1
votes
3 answers

How to open DBF(dBase) file faster way and update it very fast using VS C#?

I want to build a program that can open dBase(DBF) file faster like other normal files. My data contains more than 100,000 lines of data. I want to build a software, that can open DBF(dBase) file faster way and modify it .Also I wan to import data…
Vish Soni
  • 43
  • 1
  • 7
-1
votes
1 answer

How to Import Data from .DBF file to Some Other Database like ElevateDB?

I have large file say named as "customers" and it is in .DBF format. Now I want to import that .DBF file data to ElevateDB database. ,,,Is ther any ways to import data by Query or write program for import from .DBF to ElevateDB...
Vish Soni
  • 43
  • 1
  • 7
-2
votes
2 answers

How do I create a column with two values (or names) at a given weight in R

I'm trying to create a column in my data in .dbf. I need to create a column in which 70% is 0 (or TRUE) and 30% is 1 (or FALSE), only at random. How can I do this?
-2
votes
1 answer

How do I export a DataTable to new DBF file in vb.net?

I have a DataTable that I've populated with a variety of data from other datatables, and the field names change often. My question is how would I export this DataTable to a DBF file? Here is what I've come up with but it simply doesn't know how to…
Chrisetiquette
  • 301
  • 1
  • 3
  • 21
-2
votes
1 answer

Read multiple DBF files in R

I have multiple DBF files in C:\Deskop\Test folder. For example, I have listed 5 of the DBF file names below.…
-2
votes
2 answers

Read records dbf foxpro 2.6 have been deleted on excel

How to read records that have been deleted. Can the record be read on excel or another software? If so, how?
-2
votes
1 answer

Windows got crashed and how to recover the old Oracle DB

unexpected Crash of windows took place. I dont have a metadata backup. After reinstalling windows i have taken the old database folder back up which has…
-2
votes
1 answer

Updating a csv with python

I am very new to python and am working on a project to automate a mapping process for several thousand shape files. My eventual goal is to get each row in my csv into a separate .dbf dbase table. The information in the last column of my csv is not…
-2
votes
2 answers

Batch DBF files into CSV files in Python

There are previous topics on this, however, the codes presented are not correct. Could anyone post a reliable code for batch processing dbf's into csv?
Tre
  • 1
  • 3
-3
votes
1 answer

Underscore in DBF file name

I'm writing a VB NET program to read dBase .dbf files using the OleDbReader. When the filename contains an underscore, the OleDbDataReader gives a file not found error, whereas the same file without the underscore in the name works just fine. Some…
etri
  • 89
  • 8
-3
votes
2 answers

How can creating dbf file, and define encoding in Notepad, or VBA

what is DBF4 (dBase IV)(*.dbf) file fundamental format? And how can create these file in a same word editor as Notepad with typing?(Update:, or excel VBA?) What is that's format specifications as: Delimiter (Same as: , or tab or etc) Separator (may…
mgae2m
  • 1,097
  • 9
  • 37
-3
votes
2 answers

how to convert .DBF file format to .dbf file format?

I want to acccess dBase database. It's not directly have any database name. it's have table name base data file. Normally dBase file format open in msaccess & msexcel. But it have .DBF file extension, so it's not opened in msaccess or msexcel. So i…
user2025117
  • 5
  • 1
  • 1
-6
votes
2 answers

Migrating .DBF files into Sql Server Database

I have some DBF files in FOxPro 9.0 But I want to migrate the data from DBF to sql server, what should I do? Can anybody provide me script or Stored Procedure to migarte the data? Also, I want to know that is it possible to convert the data in DBF…
1 2 3
48
49