Andy Lacey
andy at minstersystems.co.uk
Thu Jul 3 11:13:13 CDT 2003
Erwin :-) you're very welcome. Glad to help. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps > Sent: 03 July 2003 17:02 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Importing DBF file with more than 1024 > fields.-WORKED AROUND > > > 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 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >