Need Macro that will update the date in a sql script entered via GET DATA/SQL in Excel to refresh data in worksheets

Question

Need Macro that will update the date in a sql script entered via GET DATA/SQL in Excel to refresh data in worksheets

Fantasia, Korena 0

I have a sql script that pulls data into a spreadsheet. I need to setup a means for end users to enter a different date into that script and then be able to refresh the output based on the new date.

Emi Zhang-MSFT 30,031 Reputation points Microsoft External Staff

2024-08-06T05:42:01.33+00:00

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 answer

Your answer

Emi Zhang-MSFT 30,031 Reputation points Microsoft External Staff

2024-08-06T05:42:01.33+00:00

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Olaf Helper 47,106

Then use a parametrized query, see

https://support.microsoft.com/en-us/office/create-a-parameter-query-in-microsoft-query-c67d9af7-c8a0-4bf7-937c-087cb25f7ad3

Share via

Need Macro that will update the date in a sql script entered via GET DATA/SQL in Excel to refresh data in worksheets

1 answer

Your answer