Im not familiar with VBA at all but have the need for some automation that will save a lot of time.

I have a xlsx file that is linked to an Access DB, so for now I'm having to open the file, click 'refresh all', save the file and close it every time i want to populate the new data.

Is there a VBA script that can help me automation this process?

Thank you.