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

  • DaniBoy
    DaniBoy

    domo

    💎

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

    Thanks!

  • DataJake
    DataJake

    domo

    💎

    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

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

    Thank you,

    Kem