having some problems at work trying to optimise a report. We run a (mySQL?) database that cannot be changed, I can access the database through Excel to run reports using microsoft query (import external data).
I have created a report in excel which pulls all the information I require from the database. On a weekly basis I will right click on the data, select Edit Query and open the SQL script to amend the dates in one of the fields, adjusting by a week. The filters are built into the script so I just have to change the figures.
Unfortunately due to the sensitive info I cant post examples nor would I have the slightest idea how to replicate it.
What I would like to do is edit the query so that it obtains the date (both top and from) information from 2 cells in the excel spreadsheet. Then I have to enter 2 dates into the spreadsheet and select Refresh data and that'll be it done.
If I could do this and understand it, it would open plenty doors for other improvements along the same lines not to mention reduce the competence of those required to run the report.
I know its highly unlikely that someone using a similar system to this but thought it worth a try?
Anyone able to help?
Thanks
Iain
I have created a report in excel which pulls all the information I require from the database. On a weekly basis I will right click on the data, select Edit Query and open the SQL script to amend the dates in one of the fields, adjusting by a week. The filters are built into the script so I just have to change the figures.
Unfortunately due to the sensitive info I cant post examples nor would I have the slightest idea how to replicate it.
What I would like to do is edit the query so that it obtains the date (both top and from) information from 2 cells in the excel spreadsheet. Then I have to enter 2 dates into the spreadsheet and select Refresh data and that'll be it done.
If I could do this and understand it, it would open plenty doors for other improvements along the same lines not to mention reduce the competence of those required to run the report.
I know its highly unlikely that someone using a similar system to this but thought it worth a try?
Anyone able to help?
Thanks
Iain
