Note:- When I tried to fetch data from non linked table, it is running successfully.īelow code is working in Excel-32 bit version, but not working in excel-64 bit.Ĭonn = "Provider=.12.0 Data Source=G:\Workflow Tools (Michael Cantor)\Tool For Fixing Bug From Michael Cantor\PI MDT Reconciliation Workflow Tool\SampleforPractice. Note:- I am manually successfully able to refresh ms-access linked table in ms-access, "peoplemain" is the name of linked table.
Version: Modified: Size: 41. 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. Mac Windows Excel ODBC Driver Read, Write, and Update Excel files through ODBC The Excel ODBC Driver is a powerful tool that allows you to connect with live Excel file data, directly from any applications that support ODBC connectivity.
0 kommentar(er)
