Export to Excel with Mutiple Sheets

Hi,
I have encountered this problem of not being able to export my different sub
reports to individual work sheets within excel. I have tried to put Page
breaks after each table, as this is all the sub reports contain. Thus after
each table a page break is inserted. If I preview the Report, containing all
the sub reports, it shows the correct page breaks. However when I export this
to Excel it gives me the following:
Sheet 1 - Document Map
Sheet 2 - First Sub Report
Sheet 3 - All the remainder of the Sub Reports straight after each other all
in one sheet.
I need to have the Sub Reports all in seperate sheets. Can anyone help,
please'
Thanks,
NatNat, I am experiencing the exact same problem. Have you gotten any info/reply
from experts? I really need answers, too.
thanks
"Nat" wrote:
> Hi,
> I have encountered this problem of not being able to export my different sub
> reports to individual work sheets within excel. I have tried to put Page
> breaks after each table, as this is all the sub reports contain. Thus after
> each table a page break is inserted. If I preview the Report, containing all
> the sub reports, it shows the correct page breaks. However when I export this
> to Excel it gives me the following:
> Sheet 1 - Document Map
> Sheet 2 - First Sub Report
> Sheet 3 - All the remainder of the Sub Reports straight after each other all
> in one sheet.
> I need to have the Sub Reports all in seperate sheets. Can anyone help,
> please'
> Thanks,
> Nat

export resultsets in ms access

I have a sp which return mutiple result set.
Is there any way by which i can export the multiple resultset data in ms
access using some tool, DTS etc.ADO in VBA supports the NextRecordset method for doing this and it is
possible in MSAccess. Check the help for NextRecordset.
Hope that helps.
Let me know how you get on.
Damien
"Vikram" wrote:

> I have a sp which return mutiple result set.
> Is there any way by which i can export the multiple resultset data in ms
> access using some tool, DTS etc.
>
>