Note:- I am manually successfully able to refresh ms-access linked table in ms-access, 'peoplemain' is the name of linked table. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message 'ODBC connection failed' showing.
