Problem about export records from access95 to excel95

Article View: comp.databases.ms-access

Article #391

Back to comp.databases.ms-access Previous Next

#391

From: Desmond Leung
Date: Fri, 15 May 1998 00:00

12 lines
1228 bytes

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: <6jh486$env$1@dover.cityu.edu.hk>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,ebb1b81f8f6d136d,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,ebb1b81f8f6d136d,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 102b1d,ebb1b81f8f6d136d,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 10cc0d,ebb1b81f8f6d136d,start
X-Google-Attributes: gid10cc0d,public
X-Google-Thread: ff0ac,ebb1b81f8f6d136d,start
X-Google-Attributes: gidff0ac,public
From: "Desmond Leung" <ckkleung@cs.cityu.edu.hk>
Subject: Problem about export records from access95 to excel95
Date: 1998/05/15
Message-ID: <6jh486$env$1@dover.cityu.edu.hk>
X-Deja-AN: 353508357
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: City University of Hong Kong
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.odbcclientserver