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

Dannytt93

New Member
Joined
Feb 13, 2019
Messages
9
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
StatusDepartmentNumber in statusDate Report Ran
OpenApplications729/03/2019
in progressApplications629/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's29/03/201905/04/2019
Open7
in progress6

<tbody>
</tbody>


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

Ticket status's29/03/201905/04/2019
Open8
in progress3

<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's29/03/201905/04/2019
Open78
in progress63

<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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
how is the sql populating the sheet, do you use vba ?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,474
Members
414,070
Latest member
DuncanLucas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top