How to Export Access Data to Excel using VBA Code? 1. Open an MS Access file 2. Press Alt+F11 3. Insert a Module (Insert>Module) from menu bar.