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

Username from Jira being sent over to Smartsheet through the Connector as an ID rather than a name.
We use the Jira connector. One of our teams has an automation running in Jira that puts the most recent comment in a field called "Last Comment". This field is being synced through the connector so that it is one of the fields that displays in Smartsheet. They noticed that Jira is passing the Jira Account ID into…
PowerAutomate Flow to get email address from last row based on condition
I'm trying to build a PowerAutomate flow based on when a new response is received to a Smartsheet form that if a certain question is answered as Needed an AdobeSign agreement is generated and emailed to the address that is filled out on the form. When I first built this, I did it very basic just to test the connections. It…
Can a summary sheet from control center act as the intake sheet for a new set of blueprints?
We currently have two blueprints, 1 intake sheet and a summary sheet. I would like to use that summary sheet as the intake sheet for a new set of blueprints Is there a problem with this type of set up?