Is it possible to refresh External Data and retain old data?

[cardinal0510]

I am importing data from a Microsoft query into excel. The query only holds the current days information, then the next day it disappears and the new data is there. I would like to be able to create a database/table that retains the old information and just inserts new rows for new information so i can store a whole months worth of data.

 

[venkat1926]

suppose the downloaded data is in sheet 1
.as soon as you download run this macro the data will be archived insheet2,

daily as soon as you download you have run the macro

Sub archiving()
Dim r As Range
Worksheets("sheet1").Activate
Set r = Range("A1").CurrentRegion
Set r = r.Offset(1, 0).Resize(r.Rows.Count - 1)
'MsgBox r.Address
r.Copy
With Worksheets("sheet2")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
End Sub