Erwin Craps
Erwin.Craps at ithelps.be
Thu Jul 3 11:01:50 CDT 2003
Andy I'm not a believer but I certanly wish that (some or all) God would bless you for this... I took a 20 second look at it, and it seems to be the tool thats gonna save my ass (today) :-). Thank You -----Oorspronkelijk bericht----- Van: Andy Lacey [mailto:andy at minstersystems.co.uk] Verzonden: donderdag 3 juli 2003 17:41 Aan: 'Access Developers discussion and problem solving' Onderwerp: RE: [AccessD] Importing DBF file with more than 1024 fields. Erwin There are a couple of utilities you might use to do this, such as dbx.exe (sorry, I don't have a copy anymore). It has a user interface including a Modify Structure facility. It'd be easy to make several copies of your dbf then use this to strip out a different set of fields from each copy. Just had a quick browse and at http://www.ozs.com/ there's a utility called WinDBU which may do the trick. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos > Sent: 03 July 2003 16:16 > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Importing DBF file with more than 1024 fields. > > > 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 > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com