Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
If I only want to copy certain columns say once a week (upload workflow) from Excel into Smartsheet to replace the previous week's data, but I don't have the option to add a Unique row ID in the Source file, is it possible to do this Data shuttle copying of only certain columns from Excel into the smartsheet data shuttle…
Hello, I'd like to do the workflow as mentioned in the title above, but I'm limited in a couple of aspects: I'm unable to add unique row IDs in my source data file (which I'm importing/uploading from Excel), does this limit my ability to use Merge (add & update) Data Shuttle workflow? If I use the Replace workflow of Data…
Hello, Is it possible to do a smartsheet data shuttle replace target sheet rows by only replacing certain columns in a row and keeping other columns in a row intact? Essentially, I want to be doing a weekly replacement of the target sheet (ie. not updating consecutive data sets) by Data Shuttle upload of an Excel sheet? I…
