Compile error due to 64-bit version of Microsoft Excel
IMPORTANT NOTE
THIS ARTICLE ONLY APPLIES TO ODBCLINK OLDER THAN V3.46.0.113
Overview
While ODBClink can run on Microsoft Excel 2003, 2007, 2010 and 2013, it used to require the 32-bit version of those products to be installed. The main reason for this was that both the MYOB ODBC driver and the QuickBooks QBFC object library are 32-bit only.
Note that ODBClink can run on 64-bit machines, but Microsoft Office must be 32-bit. If you tried to run ODBClink on a 64-bit version, you would receive a compile error when ODBClink first start.
Also note that Microsoft Excel 2003 and 2007 are only available as 32-bit versions and are not affected by this issue.
If you do have Microsoft Office installed as a 64-bit version, you may need to uninstall it and install the 32-bit version which is located on the same disk.
How to check the version of Microsoft Excel 2010
- Start Microsoft Excel;
- Click on the File button;
- Click on the Help entry in the list;
The full version number, including 32-bit or 64-bit version is listed on the right hand side of the screen.
How to check the version of Microsoft Excel 2013
- Start Microsoft Excel;
- Click on the File button;
- Click on the Account entry in the list;
- Click on the About Excel button;
The full version number, including 32-bit or 64-bit version is listed in the first line.