SQL Data import overwriting previous data that report is based on.

[Dannytt93]

Hello,

I have a connection to an SQl Database running on excel. There is another tab with several formulas that all look at the imported table which has several columns.

the table imported looks as follows

Status	Department	Number in status	Date Report Ran
Open	Applications	7	29/03/2019
in progress	Applications	6	29/03/2019

<tbody>
</tbody>

This works great when i want to import the data into the table BUT.. when i change the date from 29/03/2019 to 05/04/2019 which is the next column along where i want it to deposit the data using a formula e.g.

Ticket status's	29/03/2019	05/04/2019
Open	7
in progress	6

<tbody>
</tbody>

The data is disappearing from column "29/03/2019" and inputting the up to date data in 05/04/2019.

Ticket status's	29/03/2019	05/04/2019
Open		8
in progress		3

<tbody>
</tbody>

Is there anyway for excel to not delete that data and just deposit the new one next to it so it looks like:

Ticket status's	29/03/2019	05/04/2019
Open	7	8
in progress	6	3

<tbody>
</tbody>

Without having to do a brand new import on a separate tab every time i want to update the data?

the idea is that it is fully automated and doesnt require any manual input. So when the report is opened on the specific date (which is once a week every friday), the data will have already populated in the correct column.

Any help would be great

Thanks in advance

Dan

 

[mole999]

how is the sql populating the sheet, do you use vba ?