Data Shuttle

10/14/21
Answered - Pending Review

Can anyone help me in this? My requirement is datashuttle should run a scheduled time (say 7 PM CST). At 6 PM CST, I have a python script that runs an SQL query and populates an Excel and saves in the OneDrive.

I have a data shuttle that picks data from an .xlsx file in my OneDrive. Now, the data shuttle is not able to pick and copy over the .xlsx file unless I go to .xlsx manually, open and save.


Can anyone help me to address this issue so that datashuttle works without me going and saving the excel manually?

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    It sounds like the data is not being updated in the xlsx file until it is opened/saved. I would suggest browsing Excel/Microsoft forums to see if there is anything there that will be able to guide you on how to get that save to trigger automatically on the xlsx file.

    thinkspi.com

Sign In or Register to comment.