This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have created a workflow to automatically pull in the the newest excel file from a shared drive and included the R tool to remove the password protection on it. However, when I use the Output Data tool to upload it to the database it throws the error:
"Error opening" "SELECT", '...column names...' FROM 'table name': No columns returned
The workflow is below - I have tried including a Dynamic Input tool between the R tool and Output data tool but this doesn't work as the Dynamic Input tool still sees the excel file as password protected