MSQuery Excel Tables runs and updates BUT NOT if ran from Task Scheduler

[Josue12]

I have an Exel file (startMSQuery) that on open it uses MSQuery to connect to the Citadel database and update values for a given date. The values get updated if the user either double clicks or performs a file open from Excel to open the file with the macros. I've configured Task Scheduler to open startMSQuery.xls but the values do not get updated with the correct date. Lower left corner of the file indicates MSQuery connecting to database but it never connects and the values don't get updated. Does task scheduler open the Excel file differently?? Please help with this issue.

 Thank you.

[Ryan.S]

Do you want to update the value in Citadel or just read value? Citadel doesn't support SQL writing, such as "update" statement.

If you just want to query data from Citadel, and it already works when you double-click the file, it is not the SQL problem.

[Josue12]

The MSQuery only "Reads" data from the Citadel database.I was looking for assistance in troubleshooting what the problem could be. I understand the SQL portion is working as intended but how is it that it doesn't work if ran from Task scheduler..