Exporting Access into Excel workbook

[Allyson]

Is there a way to export an access report into excel
workbook where data is broken out onto multiple
spreadsheets? Please help.

Thank you!!

 

[BrianB]

In the absence of another reply ..... I think not.

In my opinion you would be better off exporting sets of data from th
*original Access table* to Excel - or using Data/Get External Data i
Excel.

I am currently experimenting with a similar job where it is necessar
to have an Access table containing worksheet names linked to the mai
table to enable this. I am setting up an Excel macro to import t
worksheets. It may be quicker to use an Access Make Table Query fo
each sheet