Import data to my access table with VBA

Hello Everyone,

I am new in Access and VBA

I have a table in MS Access : "Polish_Terminations_Tracker_2018"

I want to import data to this table with VBA. Import data will be another excel file which I will make user browse in his desktop. The import data has exact same columns. I want to add the content of that import data, to the end of my table.

I have below code but its not working. Any idea ?

Thanks !

Please Login or Register  to view this content.

In the above code, you are deleting all the data in your table first. If this is what you want, then instead of importing your excel file after the deletion, then link your file to Access and the linked file becomes a linked table that you can then perform all of the necessary Access functionality. Additionally, every time you update or change the excel file, it is immediately linked/synced to the table as they are one in the same.