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 recently started a trial of Data Shuttle for our company and am applying it to a specific use case. Currently, it’s configured to extract data from Excel template files attached to a landing grid (submitted via Form) and load that data into another grid. This works well when submissions come in one at a time. However,…
I have a flow that runs every 15 minutes and it compares the date and time the row was created with the current time and it writes that difference in time to a column to easily show how long a row has been waiting to be worked. The only thing I'd like to change is to make time value it updates each row with always be a…
When we try to link Smartsheet to Hubspot our bid amount column (text/number w/ currency formatting) is translating over to Hubspot as a string instead of just numbers. For example $10,000 comes out as "10000". Hubspot just wants it to show as 10000. We have tried removing the currency formatting on the Smartsheet side and…
