[QODBC-ALL] Using QODBC with Office 64-Bit
Posted by Rajendra Dewani (QODBC Support) on 21 August 2019 07:58 AM
Using QODBC with Office 64-Bit
QuickBooks is a 32-Bit application, but other applications such as MS Excel, MS Access, and MS SQL Server are also available in 64-Bit architecture.
Since a 64-Bit application cannot talk to a 32-bit driver, we have to do a bit of magic to get the worlds to connect, and we call it QRemote. QRemote works as a bridge between 64-Bit Applications and the 32-Bit QODBC Driver by communicating data calls between the two worlds using TCP/IP protocol. QRemote allows 64-Bit Web Servers and 64-Bit applications to talk to QuickBooks live for the first time via the QODBC Driver.
To use QODBC with MS Office 64-Bit, you need to use QRemote. This feature (QRemote) is built-in to fully licensed versions of QODBC.
For Excel: Click Here
For Access: Click Here
For QODBC bundled with QuickBooks Enterprise Edition, we suggest installing Office 32-Bit - How to convert MS Office from 64-bit to 32-bit.