Article View: comp.databases.ms-access
Article #393Re: Problem about export records from access95 to excel95
From: George Fehrenbach
Date: Fri, 15 May 1998 00:00
Date: Fri, 15 May 1998 00:00
34 lines
1720 bytes
1720 bytes
You can also restrict the number of records by using the "Top" keyword in the SQL statement. -- George Fehrenbach georgef@geoaccess.com Terry Kreft wrote in message ... > > >You would have to use a series of queries to reduce the recordset to less >than 16384 records. > >You restrict the numer of rows by using a where condition. > > >Desmond Leung wrote in message <6jh486$env$1@dover.cityu.edu.hk>... >>Hi all, >> >>Does anyone know how to export more than 30000 records from access95 >>to excel95. as the default row size of every worksheet is 16384.? Also, >does >>anyone >>know how to restrict number of records that are affected by SQL in any >>version of Access >> >>Many Thanks, >> >>Desmond Leung >> >> > >
Technical Details
Message-ID:
<6jhqqi$j77$1@news0-alterdial.uu.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6jh486$env$1@dover.cityu.edu.hk> <urpRHOBg9GA.193@uppssnewspub04.moswest.msn.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101bdd,ebb1b81f8f6d136d X-Google-Attributes: gid101bdd,public X-Google-Thread: 111a5a,ebb1b81f8f6d136d X-Google-Attributes: gid111a5a,public X-Google-Thread: 10cc0d,ebb1b81f8f6d136d X-Google-Attributes: gid10cc0d,public X-Google-Thread: ff0ac,ebb1b81f8f6d136d X-Google-Attributes: gidff0ac,public X-Google-Thread: 102b1d,ebb1b81f8f6d136d X-Google-Attributes: gid102b1d,public From: "George Fehrenbach" <georgef@geoaccess.com> Subject: Re: Problem about export records from access95 to excel95 Date: 1998/05/15 Message-ID: <6jhqqi$j77$1@news0-alterdial.uu.net> X-Deja-AN: 353553812 References: <6jh486$env$1@dover.cityu.edu.hk> <urpRHOBg9GA.193@uppssnewspub04.moswest.msn.net> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.odbcclientserver