Hi,
I have the following code which works fine in MS Access 2007. It export current access form records to an excel sheet:
DoCmd.OutputTo acOutputQuery, "RunQuery", acFormatXLSX, , True
Is it possible to append data from this form to an existing excel sheet instead of creating new one or replacing the existing one?
Your help is highly appreciated