Having SmartSheet open itself nightly without requesting the password

Hello:


I have SmartSheet working as a source of data for an Access database through and ODBC connection.


Nightly we run an update of the SmartSheet data into Access.


I would like to set this up to run on MS Task Scheduler, but I’m seeing no way to have the password save itself in SmartSheet. This makes it necessary for someone to log in nightly to do this update.


Is there any way the password can be saved in SmartSheet so when the system runs at night Smartshet opens itself up?


Thank you,

Robert

Answers