Question: how to export data from access to excel using macro?
Answer: Click on the "Macros" option in the "Objects" menu. Click "New" in the upper-panel of the database window to create a new macro. Click in the "Action" field. Click on the drop-down arrow and go to "MsgBox".