Hi Guys,

Need a bit of guidance. I am writing a procedure that exports over the maximum to excel. Now I know that we could do this to .CSV, however the person needs this in excel to be able to open and do pivots etc etc. My problem is that I need to be able to split this onto multiple sheets. I have got the recordset open with all the records.

I have now come to the stage where I just can't think anymore. Can someone give me the guidance I am looking for. I know about the offset and counting the records. Its just getting it all into the right order.

All help is much appreciated

You could create a query, and then set it to TOP 65000.

Then do a second query to find unmatched from your table to the TOP 65000 query (hopefully you don't have more than 130000 records.)

Then export the TOP 65000 query, and then export the find unmatched query. Too simple?

HTH

mmcdonal

There is a cunning little trick, if you name the qry doing the work X and the workbook Y, when you add subsequent X+1 qry's to the Y workbook, the X+1 data will go into its own worksheet...

X and X+1 must be named differently though, the qry themselves.

Food for thought

Thanks Guys, See went brain dead last night. I will certainly look at this and let you know.

Thanks again