vba on datasource

[Dwjenkins]

Hi All

I have connected Microsoft Query to download from my SQL Server with a Parameter from a cell.

However, when it runs it deletes all the information within the table. But what I want it to do is append the date to the end.

Basically, cell A2 has a DateID based on the formula =max(N:N)-8, the query then returns all date for the past 8 weeks. It should then overwrite the 7 weeks of data with anything thats changed and the 8 week will always be new data.

I am assuming that I need some vba wizardy here.

 

[wrightyrx7]

You already have a Macro to do to fetch the data? You just want the code amending to put the new data in the correct location? (If so can we have a look at the code)

 

[Dwjenkins]

No its not a macro, it comes from a DataSource through microsoft query.

I was thinking about this earlier and 'updating might not be best way of doing it. I think it should probably delete the last 7 weeks of data and then once the DataSource is run it should append the data to bottom of the current table.