I have an automatically feeding data stream from our accounting program which automatically updates daily.
Tell us about that Stream... What format is it in? What is the mechanism you receive it by? What is it's structure?
i need to craft a [] query
Tell us about the Data Base... What is the Connection String? What is/are the names of the Tables of interest? What are the Fields of interest? What is the relationship of the Fields to the Columns/Headers of the Table you want to create?
Without knowing all that, mana has already provided the best answer we can, given the paucity of information in your post.
OK, I can expand on mana's code a tiny little bit
For each day
Sheets("SheetName").Cells(rows.count, "A").End(xlUp).Offset(1) = Range(datastream)
Next