Re: Problem about export records from access95 to excel95

Article View: comp.databases.ms-access

Article #392

Back to comp.databases.ms-access Previous Next

#392

From: Terry Kreft
Date: Fri, 15 May 1998 00:00

24 lines
1487 bytes



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: <urpRHOBg9GA.193@uppssnewspub04.moswest.msn.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6jh486$env$1@dover.cityu.edu.hk>

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: ff0ac,ebb1b81f8f6d136d
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10cc0d,ebb1b81f8f6d136d
X-Google-Attributes: gid10cc0d,public
X-Google-Thread: 102b1d,ebb1b81f8f6d136d
X-Google-Attributes: gid102b1d,public
From: "Terry Kreft" <terry.kreft@mps.co.uk>
Subject: Re: Problem about export records from access95 to excel95
Date: 1998/05/15
Message-ID: <urpRHOBg9GA.193@uppssnewspub04.moswest.msn.net>
X-Deja-AN: 353531759
References: <6jh486$env$1@dover.cityu.edu.hk>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: MPS
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.odbcclientserver

Reply to Parent Message