7/27/2023 0 Comments Peachtree to excel 64 odbc![]() 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. need ODBC (64 bit) Driver for excel (version 12 and after) on windows. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |