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.
Hello! We are a Graphic Production facility and use Smartsheet to track projects and their graphics from conception to completion. Each project has a workspace that is created with multiple matrices and we use a 'Production' matrix to keep track of all graphic items we are to produce. Our pain points currently have to do…
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
upload workflow runs perfectly, but the filter has projects less than 31st march 2025
