Exporting a Report/Query from Access to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy - 13 Jul 2005 12:31 GMT

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

Reply to this Message

JackP - 13 Jul 2005 13:38 GMT

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.

Reply to this Message

Jimmy - 14 Jul 2005 12:24 GMT

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

> Hi,
> I was looking to export data from an Access (2003) Report or Query into an
[quoted text clipped - 6 lines]
> Thanks
> Jim

Reply to this Message