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

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…
How to remove rows from a DataTable using DataShuttle when the source sheet has rows removed?
I have a DataTable that is currently populated by a DataShuttle. When I upload the source report to a sheet, the data gets added into the DataTable via DataShuttle. The DataShuttle is configured to "add rows when added to the source file" and "update rows as they change in the source file". The unique column identifier is…
Data Shuttle: Duplicated Data with Different Creation Dates
Hello! I am working on a new Data Shuttle workflow and have come across an issue I haven't encountered before. I have to run an annual audit on a list of employees through a third-party site. I am able to download the query results of the audit from the third-party site, and I would like to use Data Shuttle to add results…