Knowledgebase
[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.

 

Office 64-Bit

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.

 

Office 32-Bit

Please refer to the following articles for How to connect and use MS Office (32-bit) with QODBC.

For Excel: Click Here

For Access: Click Here

Video - Click Here

 

(3 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).