[AccessD] Importing DBF file with more than 1024 fields.

Gary Kjos garykjos at hotmail.com
Thu Jul 3 10:16:10 CDT 2003


Dbase IV only allowed 255 fields. dBASE V went to 1024 according to this;

http://prestwood.com/community/database/info/dbase_spec.html

---------------------------
dBASE IV Table Specification
The dBASE IV table format was introduced in dBASE IV for DOS. Following are 
the specifications for dBASE IV tables.

2GB file size.

Two billion records per file.

A maximum of 255 fields per record.

Maintained indexes can have up to 47 indexes per file. Each index can be 
created using field expressions of virtually any combination, including 
conditional expressions of up to 255 characters per expression that result 
in an index of up to 100 bytes.

Unlimited nonmaintained indexes can be stored on disk. You can use up to 47 
of them simultaneously.

dBase V Table Specifications
The dBASE V table format was introduced in dBASE V for Windows. Following 
are the specifications for dBASE V tables.

Up to one billion records per file.

A maximum of 1,024 fields per record.

Up to 32,767 bytes per record.

Unlimited nonmaintained indexes can be stored on disk. You can use up to 47 
of them simultaneously.

Up to 10 master index files open per database. Each master index can have up 
to 47 indexes.

Maintained indexes can have up to 47 indexes per file. Each index can be 
created using field expressions of virtually any combination, including 
conditional expressions of up to 255 characters per expression that result 
in an index of up to 100 bytes.


Gary Kjos
garykjos at hotmail.com





>From: Erwin Craps <Erwin.Craps at ithelps.be>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Importing DBF file with more than 1024 fields.
>Date: Thu, 3 Jul 2003 15:53:49 +0200
>
>I was wrong about Excel...
>
>I can open the file but do not see all fields...
>Only some 250 of the +/- 1200 fields...
>
>Looks I gonna need to program same direct file access code to split up the
>file...
>
>Anybody knows if Dbase 4 already supported that many fields?
>I still have Dabes 4 somewhere in my basement, if diskettes not to dusty 
>:-)
>
>Erwin
>
>
>-----Oorspronkelijk bericht-----
>Van: Gary Kjos [mailto:garykjos at hotmail.com]
>Verzonden: donderdag 3 juli 2003 14:42
>Aan: accessd at databaseadvisors.com
>Onderwerp: Re: [AccessD] Importing DBF file with more than 1024 fields.
>
>
>If you can get at it in Excel can you cut and paste it into multiple 255
>field (or less) worksheets? And them import those. Access has a limit of 
>255
>
>on fields I beleive.  You would need to have some common key value in each
>worksheet in order to join it all back together.
>
>Gary Kjos
>garykjos at hotmail.com
>
>
>
>
>
> >From: Erwin Craps <Erwin.Craps at ithelps.be>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
> >Subject: [AccessD] Importing DBF file with more than 1024 fields.
> >Date: Thu, 3 Jul 2003 09:23:54 +0200
> >
> >Hi
> >
> >I need to import or link a DBF file.
> >Nothing special about that next to the fact I have a DBF file with more
> >than
> >1024 fields...
> >I can link but access returns error opening it or even with building a
> >limited SQL query.
> >
> >I tried to import in SQL server 2000, but same issue, to many fields.
> >However, I can open the file in Excel.
> >
> >Anyone an idea what to do?
> >
> >Thx
> >
> >
> >
> >
> >Erwin Craps
> >
> >Zaakvoerder
> >
> >www.ithelps.be/jonathan <http://www.ithelps.be/jonathan>
> >
> >
> >
> >
> >This E-mail is confidential, may be legally privileged, and is for the
> >intended recipient only. Access, disclosure, copying, distribution, or
> >reliance on any of it by anyone else is prohibited and may be a
> >criminal offence. Please delete if obtained in error and E-mail
> >confirmation to the sender.
> >
> >IT Helps - I.T. Help Center  ***  Box Office Belgium & Luxembourg
> >
> >www.ithelps.be <http://www.ithelps.be/>   *  www.boxoffice.be
> ><http://www.boxoffice.be/>   *   <http://www.stadleuven.be/>
> >www.stadleuven.be
> >
> >IT Helps bvba* ** Mercatorpad 3 **  3000 Leuven
> >
> >IT Helps  *  Phone: +32 16 296 404  *  Fax: +32 16 296 405 E-mail:
> >Info at ithelps.be <mailto:Info at ithelps.be>
> >
> >Box Office **  Fax: +32 16 296 406 **  Box Office E-mail:
> ><mailto:figures at boxoffice.be> Staff at boxoffice.be
> >
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>_________________________________________________________________
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus



More information about the AccessD mailing list