Welcome!

Integrate with Microsoft Access

Jwindels

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?

Find more posts tagged with

Non-profit

Sheets

Integrations

Marketing

Solution Center

Project Management

Importing and Exporting

Media & Entertainment

Comments

PPS Solutions

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

Thomas Love

"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...

Marian Hanright

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Datamesh Source Missing
I set up a datamesh workflow and then when trying to run, datamesh couldn't locate the source report. I have confirmed I am an admin on the source and the target. Is this is a support issue or a me issue?
Dynamic View Editing Role
Hi all, I want to utilize the Smartsheet Dynamic View. Considering the "editor access" type in smart sheet I wonder if the users are aimed to edit the view, should have the editor role? If I am not shared the file with them, will they stay as a Smartsheet user with viewer settings but are able to view the file? Thank you!
Row ID for row created in the previous module is coming back as not existing.
I'm running into an issue in Bridge where a row I just created via the Add Row module, is coming back as not found when I try to use a Get Row module, referencing the row it just created. Goal: I have a workflow where I am adding a row to Sheet B, by copying data from sheet A. When that new row is created, an Auto Number…