I’m using Excel to pull data from a SCADA database through ODBC for reporting. I have my data in Excel but I need to set a range to pull the data everyday for a month and then when the month is over, and I change the month on the main sheet (ex. From April to May) it will clear the old data and start recording the new months data.
The SCADA server has a historian that stores the data so the data is always there. I just need to be able to set a monthly date range to import the data into the spreadsheet and have an easy way of changing the date range.
All help is appreciated. Thanks.
I’ve tried using the Timestamp function and the “?” Query but I can’t seem to get the code how it should be.
Andrew Christ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.