docmd.outputto vs docmd.transferspreadsheet (1 Viewer)


New member
Nov 3, 2006
may somebody help me please.

I need to export my report to excel
I use docmd.outputto, the result is oke, but it only write to single sheet, it can repeat to sheet2 sheet3 etc.

I use docmd.transferspreadsheet, it cannot work if the source to export is report. It only work if the source is table.

Do I wrong...?

My focus is, write to same xls file to multi sheet in that xls file.
For example, i have 5 report in access, need to export to destination.xls to sheet1 sheet2..... sheet5.

Please help me

Thanks very muccccchhhhhh

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom