Uploading Excel To Access automatically

[mr moe]

I want to load multiple Ms-Exell files into Ms-Access table automatically through Procedure / Macros. The files will be in the same folder. How to do this process?. Can anyone help if you have done it in code. Thanks.
"I already know how to do it thru get external data"

 

[pbaldy]

Take a look at TransferSpreadsheet in VBA help (or the macro action).