Question: how to import data into access from excel 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.