Hello


I am working on a project in Microsoft Access and need some advice with VBA code to automate the data import process.
I am trying to achieve ; the data is in multiple Excel files located in a specific folder. I want to import the data into an existing Access table.

The Excel files have a consistent structure ; I need to loop through all the Excel files in the folder and import the data into the Access table.
I would like to include error handling to skip files that might have issues and log any errors.

I have referred https://stackoverflow.com/questions/14155163/linq-entities-everything-or-nothing-in-database/14155600#14155600#msbi guide but still need help .

I have some experience with VBA but am not sure how to put all these pieces together. Any guidance on how to accomplish this would be greatly appreciated.

Thank you in advance for your help!


Best regards,

gregbowers