Click on start menu, right Click on My Computer -> Properties -> Advanced system settingsĢ. We need to add the SysWOW64 directory to the system path, as follows 1. Utilities for 32 bit operations are found in the C:\Windows\SysWOW64 directory. In order to use a 32 bit ODBC driver on a 64 bit Windows machine, it has to be configured using a 32 bit ODBC Administrator which is not visible through normal Windows menu options. So i downloaded Windows (x86, 32-bit), MSI Installer from this link In my case, i am using windows7 64 bit, excel is 32 bit, mysql is also 32 bit For this open excel file and start the task manager and check your bit architecture under Processes option. Now after that please ensure your excel-2007 is 32 bit or 64 bit. MySQL: check what version : 32 bit or 64 bit? You need to ensure your Mysql running on 32 bit or 64 bit. msi or zip file according to your computer bit architecture. Please download correct ODBC driver from the authenticated link To connect your excel-2007 (or any version) with your mysql you need ODBC driver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |