I am trying to output my query results to excel. The
amount of records I may have in the query more then 65536,
which is greater then row count in excel in one sheet.
Most likely, I will output my results to more then one
excel spreadsheet. I need to divide the query records,
and use the records partially. I know, how I would count
my records in the recordset:

Set rs = CurrentDb.OpenRecordset("Select count(*)AS
RowCount FROM qryDailyFinal", dbOpenSnapshot)

And again, I don't think that is what I am looking for.
Is there a way in splitting the recordset and use partial
records to copy to excel?

Thank you in advance,

Malvina

Get the query to include a primary key value from one of the tables
involved. Then do the query twice: once where PK < "H", then again where PK
>= "H" (or whatever: I'm sure you get what I mean).

HTH,
TC


Malvina <(E-Mail Removed)> wrote in message
news:10b001c38782$300862a0$(E-Mail Removed)...
> I am trying to output my query results to excel. The
> amount of records I may have in the query more then 65536,
> which is greater then row count in excel in one sheet.
> Most likely, I will output my results to more then one
> excel spreadsheet. I need to divide the query records,
> and use the records partially. I know, how I would count
> my records in the recordset:
>
> Set rs = CurrentDb.OpenRecordset("Select count(*)AS
> RowCount FROM qryDailyFinal", dbOpenSnapshot)
>
> And again, I don't think that is what I am looking for.
> Is there a way in splitting the recordset and use partial
> records to copy to excel?
>
> Thank you in advance,
>
> Malvina