Thread View: comp.databases.ms-access
3 messages
3 total messages
Started by Desmond Leung
Fri, 15 May 1998 00:00
Problem about export records from access95 to excel95
Author: Desmond Leung
Date: Fri, 15 May 1998 00:00
Date: Fri, 15 May 1998 00:00
12 lines
1228 bytes
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
Re: Problem about export records from access95 to excel95
Author: Terry Kreft
Date: Fri, 15 May 1998 00:00
Date: Fri, 15 May 1998 00:00
24 lines
1487 bytes
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 > >
Re: Problem about export records from access95 to excel95
Author: 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 >> >> > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads