Connect DOMO to Table in MS Access Database Saved to Local Hard Drive
Hello,
I've read the existing "asked and answered" post on this subject but am still at a loss in understanding what should be (?) a simple connection to an existing table in a locally-stored MS Access database. I can create a .dsn file to the database but am unable to point to it using a DOMO connector and/or Workbench. Can anyone provide additional guidance on this topic?
Sincere thanks,
Kem
Comments
-
Can you post a link to the article or post you read so we know what you are referring to?
Thanks!
0 -
Hello @user11319 ,
The Cloud Connector for Access is SFTP connections only, so you will use Workbench and connect through the ODBC driver to query the tables stored locally. For more info, Check out this post in Dojo for the solution
Jacob Folsom
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hi - the link that DataJake provided is the previous asked/answered that I referenced before.
Thank you,
Kem
1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive