Questions tagged [dbase]

dBase II was the first widely used database management system (DBMS) for microcomputers. The dBase system includes the core database engine, a query system, a forms engine, and a programming language that ties all of these components together. dBase's underlying file format, the .dbf file, is widely used in many other applications needing a simple format to store structured data.

291 questions
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
  • 88,211
  • 155
  • 421
  • 625
10
votes
1 answer

Sample dBase files

I am working on a program that will need to read different dBase files. I can only seem to find dBaseIII plus files for testing. Does anyone know where I can find a test pack or something? I need to test this code on different versions of dBase.
user3847280
  • 137
  • 1
  • 1
  • 8
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
  • 38,609
  • 36
  • 119
  • 151
8
votes
3 answers

How to crack a dBase file password?

I've inherited a bunch of dBase (.dbf) files from a legacy application, and I need to import the data into MS SQL or MS Access. I know these programs have built in "import" functions, but the dBase files are protected with a password, which nobody…
Shaul Behr
  • 36,951
  • 69
  • 249
  • 387
7
votes
11 answers

What is the best way today to maintain clipper 5.3 code?

Are there any successor products on DOS, Windows or Linux?
Aydya
  • 1,867
  • 3
  • 20
  • 22
7
votes
3 answers

How to open DBase files (.DBF) in Matlab?

I've googled and searched through Matlab Central, but cannot find any way to open DBF files directly in Matlab. There are some references to DBFREAD function in TMW File Exchange, but it's not available anymore. Is it really a problem? I do have…
yuk
  • 19,098
  • 13
  • 68
  • 99
6
votes
1 answer

Why does setting a table's RecNo property not move to that record?

I have got a TTable component that uses the BDE to access a DBase table. There is no index on the table, so the sort order is the physical order of the records in the table. If I read the RecNo property, it contains the expected number for the…
dummzeuch
  • 10,975
  • 4
  • 51
  • 158
6
votes
1 answer

DOS legacy application with USB printer

I have the unfortunate task of doing (minimal) maintenance work on two legacy applications developed in DBIII+/Clipper '87. I have full access to source and a minimal toolchain to recompile the application when needed, but I am not allowed to…
p.marino
  • 6,244
  • 3
  • 25
  • 36
6
votes
3 answers

how to query DBF(dbase) files date type field in where and between clause

I have a DBF file and I'm trying read it from c# code. I can read files successfully without applying any conditions or applying conditions for varchar type fields.My problem is I have to filter the records from the Date field (type:date). I have…
user1450810
  • 173
  • 2
  • 6
  • 14
5
votes
4 answers

Python dbfpy and FoxPro

I am using an ancient database format here, dbf files. Don't ask why, just know a certain software decided to extend foxpro support because microsoft decided to extend foxpro support. Now, I'm getting the following error on a specific file. I have…
Dalton Conley
  • 1,599
  • 2
  • 28
  • 36
5
votes
3 answers

Efficient way to bulk insert into Dbase (.dbf) files

Im currently using OleDBCommand.ExecuteNonQuery (repeatedly called) to insert as much as 350,000 rows into dbase files (*.dbf) at a time from a source DataTable. I'm reusing an OleDbCommand object and OleDbParameters to set the values to be inserted…
Harindaka
  • 4,658
  • 8
  • 43
  • 62
5
votes
3 answers

How to open DBF file in DBeaver with JDBC

I'm not sure why I can't connect to .DBF files using DBeaver with the built in JDBC driver for "Flat Tiles (CSV/DBF). I have a share drive with dozens of DBF files on it. I create the connections as shown in the attached images, but when I connect…
Frantumn
  • 1,725
  • 7
  • 36
  • 61
5
votes
1 answer

Get OleDbCommandBuilder 's generated SQL commands

I use OleDbDataAdapter and OleDbCommandBuilder to fill DataSet object with database contents, and then update database according to a changes that I made in the DataSet. The problem is that I get the exception: "Concurrency violation: the…
plavozont
  • 807
  • 9
  • 17
5
votes
1 answer

Export Access Table to dBase file from Excel VBA?

I have an Excel "Application" where users add/edit/etc. data. When ready, they export this data, the final deliverable needing to be a dBase file. Since Excel 2007 no longer has the Save As dBase feature, I've created the following code to export my…
Analytic Lunatic
  • 3,853
  • 22
  • 78
  • 120
5
votes
1 answer

How to read a non-standard DBF memo (BLOB) file from ACT?

I am trying to convert data from Act 2000 to a MySQL database. I have successfully imported the DBF files into individual MySQL tables. However I am having issues with the *.BLB file, which seems to be a non-standard memo file. The DBF files,…
Rowan Parker
  • 794
  • 2
  • 7
  • 18
1
2 3
19 20