Sign in to join the conversation:
Does Smartsheet allow for integration with Access database tables?
Is this something that a connector is needed for; such as Data Uploader?
Will the integration work with older editions of Access or only Microsoft 365?
HI, Integration is possible via the Smartsheet Data Connector - https://www.smartsheet.com/marketplace/apps/live-data-connector . Although it does not mention Access specifically it does work with Access and with normal desktop versions of Access as well as the version delivered via 0365. The connector will provide a read only link to your Smartsheet sheets and reports.
If you need to be able to pass back data from Access to your sheets then that is a job for some custom code written using the Smartsheet API. We provide custom apps that do this.
cheers
Dan
"If you need to be able to pass back data from Access to your sheets then that is a job for some custom code written using the Smartsheet API. We provide custom apps that do this."
Could I get some more information on the custom apps your are referring to...
I would like to link an Access query to Smartsheet. The query needs to be refreshed by the user within Smartsheet so as to provide the most current information available.
I understand that users have access to the calendar app calendar for a particular item if they have access to the source sheet or report. If I create a report that looks at two sheets and then give view access to a group that only has access to one of the 2 underlying sheets, they will only see the information from that…
If user A owns a data shuttle and set it up to save the csv in an offload workflow to that individuals google drive and then user A goes on vacation and user B now is responsible for running the manual shuttle. When user B ran the shuttle, it created a NEW csv offload file. Is that because of the setting having to do with…
I have set up DataShuttle in Smartsheet to automatically offload files and replace existing versions in Google Drive . Unfortunately, the replacement feature is not working as expected, and the files are not being overwritten properly. Can you please support to get this fixed?
