![]() ![]() ![]() 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. You can also refresh your Excel reports and summaries automatically from the original source database whenever the database is. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel. 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. You can use Microsoft Query to retrieve data from external sources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |