Connect DOMO to Table in MS Access Database Saved to Local Hard Drive

user11319
user11319 Member
in Connectors

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

  • [Deleted User]
    [Deleted User] Member

    Can you post a link to the article or post you read so we know what you are referring to?

    Thanks!

  • JacobFolsom
    JacobFolsom Domo Employee

    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"
  • user11319
    user11319 Member

    Hi - the link that DataJake provided is the previous asked/answered that I referenced before.

    Thank you,

    Kem

Categories