SQL query sharepoint list

I have a list in SharePoint that I want to query.
I’ve currently pulled that list into Access using a linked table.
I can query it successfully while in studio, but when I run orchestrator an error message says

"The Microsoft Access database engine could not find the Object “TableName”. If the “TableName” is not a local object, check your network connection or contract the server administrator.
And this only occurs when the UiRobot is running the query.

So how can I fix this so it sees the Table.
Or how else can I query the Sharepoint list outside of using a REST call.