Question: how to export data from excel to access using vba?
Answer: Open Excel.
Press ALT + F11.
VBA Editor will OPEN.
Click anywhere in the Project Window.
Click on Insert.
Click on Module.
In the Code Window, Copy and Paste the below mentioned Code. Sub ADOFromExcelToAccess() ... 
Once this is pasted, go to the Excel file.