HI, Integration is possible via the Smartsheet Data Connector -//www.santa-greenland.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.
如果你需要可以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.
"如果你需要可以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...
"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."<\/em><\/p>
Could I get some more information on the custom apps your are referring to...<\/p>","bodyRaw":"[{\"insert\":\"\\\"//www.santa-greenland.com/community/discussion/63306/\"},{\"attributes\":{\"italic\":true},\"insert\":\"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.\\\"//www.santa-greenland.com/community/discussion/63306/\"},{\"insert\":\"\\n\\nCould I get some more information on the custom apps your are referring to...\\n\"}]","format":"rich","dateInserted":"2020-09-10T20:07:20+00:00","insertUser":{"userID":125937,"name":"Thomas Love","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Love","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-10T20:05:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/262549#Comment_262549","embedType":"quote"}">
https://community.smartsheet.com/discussion/comment/262549#Comment_262549
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.