DBF Limit?

[BenReed]

How many records a DBF can hold? I have a basic normal address database with 16,000,000+ records and when importing SDF... I cannot open the file. Any thoughts?

 

[Elkari]

Clipper claims it can have a DBF hold 1 billion records. BUT, if each record has a lot of fields, the number is less but far more than your 16 million. If you are using Summer '87, you'll start getting index trouble after 500,000 records.

As far as not being able to open the file, are you getting any errors when appending to it from a SDF?

 

[EzLogic]

I have a database that contains 30M record.... I had it on a CD and I imported it from Access into clipper.... I am using clipper 5.2, no problem... I use the database for addresses also.... (to verify addresses for mailing labels, Zi+4 and CASS Certified) stuff..

YOu shouldn't have anyproblem! Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[BenReed]

I don't have any problems to append all these records but when completed I still cannot access the .dbf using old DOS Clipper 5.3 and or other compiled programs using Clip-4-Win.

All I have been able to do is to import all records in this .dbf file to a MySQL database without any problems.

 

[HotEye]

Is the Clipper app. creating the dbf and appending the SDF file itself? If it is then it should be able to read it!

If another app. is creating the dbf from the SDF file, can you specify the version, i.e. it must be dBASE III format.