Peachtree to excel 64 odbc9/5/2023 ![]() ![]() accdb) files and Microsoft Office Excel 2010 (. 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. Per you description and provided link, it seems that you want to install excel drive for ODBC via the tool provided by this link, from this link, I noticed that the components you downloaded can transfer data between existing Microsoft Office files such as Microsoft Office Access 2010 (.mdb and. 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 |