I can't help with the hive metastore only in access - are you sure you're using a databricks endpoint that has unity catalog support? I could see my UC in both access and excel

dsnless in excel

From ODBC > advanced options > paste in your connection string

I just choose custom/default as the auth type for oauth2.0 and leave the login/password box blank