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

My number format/layout doesn't hold when I do a Data Shuttle offload - how do I change this?
I am trying to figure out how to make it to where my number columns don't change when I offload. I have attached screenshots of what happens when it offloads. I am not able to edit the excel file that it creates. And my column is properly formatted in smartsheet. What is a good way to avoid this?
Dynamic View attachments - viewing pictures on mobile
Good afternoon, Our users need to be able to view attached pictures in Dynamic View on mobile without downloading them as attachments first. I suspect changing a browser setting would do the trick, but I cannot figure out how. Here's the oddity I've encountered: If I install the app, and then click a Dynamic View I'm…
Can you edit data from the View Display in Dynamic View?
This may be a silly question, but can you edit data while on the View Display in Dynamic View? I would like my user to be able to view form submission data from the Details Panel, but update status and approvals from the View Display. I could flip flop the two, but visually, this would be better for my users if possible.