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. The 'Connection Properties' window opens. Press 'Properties' to decide how you want the parameter to be set. I am presented with the 'Import Data' window shown in Fig. 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. Click add and it prompts for a value, type one in and then press 'Close' and then select 'Return Data to Microsoft Excel' from the 'File' menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |