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 set up a Data Mesh to sync contacts between 2 sheets. The goal is to sync the drop down contact list. Both columns are set to Contacts. However, when I get to the set up screen Confirm and Create, the Lookup Values field in the Source sheet is black and I can't manually add it. IT was set up correctly in the Map Sheet…
Hi All - We are using Data Shuttle to offload content to sharepoint for the first time, and I've made sure my headers match, etc. I've tried both CSV and EXCEL. I'm at a loss at this point, and have seen others suggest similar issues without much detail on 'resolution' - any insight is greatly appreciated. Same error, same…
Hi, I think I have a strange behaivour in one of the Profile Data parameters set in Control Center. Even that I do designate a Target Column as "Date" for the Profile Data in SCC, this data keeps appearing always in the default column in the template: text/number column to the right of the Primary Column in the template…
