Power Query Appending new CSV files to an EXISTING Excel table

[meg_a_bytes]

I have researched but can't find specific instructions on how to append new monthly CSV files to an existing Excel Table. The table is a collection of all of the previous month's CSV's. All of the example i have found explain how to import CSV's to a new table. I have been doing this in the past but now the list of existing CSV's (old and new) is getting long and i don't see a need to re-import previous month CSV's. My current workflow is to extract, transform the CSV's to make them all consistent then load them to a new worksheet and table. Is there a way of preserving the previous month's table and just adding the new month's CSV's? I'm not interested in in doing any VBA code if that is the only solution.

 

[jdellasala]

i was not implying that YOUR solution was to copy anything. I was coming to the conclusion that if i created tblNewMonth, i could simply cut and paste it into tblTransactions!
relax

Or just click Refresh All. No opening another file, no copy, no paste. Watch this video, particularly Example 3. Then decide. I'm done here though.

 

[GraH]

You can try to

1. Buffer the previous result, by loading it from table/ range. Copy/ paste this above the original source step. Wrap inside Table.Buffer
2. At the end of your Query add a step using table.combine( buffered query, previous step)
3. Save

This way you are not re-importing. But buffering also takes up memory.

 

[DoomBlasZt]

I think I have same problem with you.

I found the solution after watch this video

Hope it helps.