2010 appending data

[Dwjenkins]

Good evening,

I am using excel 2010 and I have created a data connection to a SQL server. The query returns all data from a given date to the prior day, however, I envisage that the data set will grow quite large and that the data will start to to take longer to put into excel.

I have been googling how to append the data onto the end of existing data in the excel sheet. I have seen a few posts that looked similar but weren't quite was I was looking for.

i think what I need is VBA that will detect the last row, give me the date from a column in that row. I then it to pass that date something Microsoft query ( correct me if I wrong but I think I have to use that to pass my SQL query the parameter) and then this will allow me to hit the refresh button and it will just get me the data from the last date.

Alternatively if there is another way of doing this please advise.

regards,

Dave.

 

[Dwjenkins]

I have done some more googling but cannot find what I need.

To to get me started how do I find the last row that has data and what a value in a date in column b on the last row would be. I will be using that in the SQL as a parameter +1.