Hi everyone,
I`d kindly ask for your help in finding a way to automatically add/import new data from another workbook to the existing table.

I`m getting last month sales data from our database monthly and I want to add it to the data of all the previous months to get a YTD sales data in one table for further analysis (Pivot). The file exported from the DB is getting overwritten each month so it is always in the same place on server and has the same name. Thus, in my analysis file, I have made a connection (Get Data-From File) to the DB exported file but the problem is that each new month the old data is getting replaced with the new data in the DB exported file.

Which type of Querry or Connection do I need to make to have the new data in the DB exported file to be added to the old data and not just replace it when I select Refresh.

Standing by for further details if needed and looking forward to your suggestions.

Many thanks and kind regards,
Jimmy