Exporting a Report/Query from Access to Excel

[Jimmy]

Hi,
I was looking to export data from an Access (2003) Report or Query into an
Excel worksheet or workbook. In doing this, I want to create a button that
performs this function, instead of clicking on export data or save as. The
reason for this is that I have a schedule in Access, but need to export to
other users that don't have Access but do have Excel. Any other ideas would
be appreciated.

Thanks
Jim

 

[JackP]

on the "on click" event for your button, click on the ... and choose code
builder.
add the following line.

DoCmd.TransferSpreadsheet acExport, , "My_TableOrQuery", "C:\MyFile.xls", True

note the two commas - I'm missing out a parameter here to accept the default.
Obviously change "My_TableOrQuery" and "C:\MyFile.xls" to suit.

 

[Jimmy]

Thanks Jack, very helpful.
However, when I tried to export data that included checkboxes(yes/no) fields
into Excel, they do not move over, any idea why?

Thanks
Jimmy