MATLAB: Matlab 64 bit Access 32 bit

64-bitdata acquisitionDatabase Toolboxodbc

We use a few access databases for storage of some of our in house data. When we have a 64 bit version of Matlab on the same machine as a 32 bit version of Microsoft Access it seems like all of our attempts to pull from the Access databases fail. I know there is an issue with 64->32 bit compatibility but is there any way around this without having to upgrade our version of Access? It's difficult to upgrade our Office package as we have many Excel add-in's from external vendors that are currently only written in the 32bit form.

Thanks for any help you can offer, Brian

Best Answer

After speaking with support multiple times it appears that this is currently not possible. The accessing of a 32 bit Office application data via 64 bit Matlab would require Microsoft to create an ODBC driver to do so. Currently there is nothing like this available.

Related Solutions

MATLAB: 32-bit and 64-bit and DB issues, oh the!

There are two ODBC managers availabe to you:

%windir%\system32\odbcad32.exe

and

%windir%\SysWOW64\odbcad32.exe

One manges 32-bit ODBCs and the other 64-bit ODBCs. Try creating your DSN in both 32 and 64 bit versions of the ODBC manager. Additionally, you might want to check the answer at: http://www.mathworks.com/matlabcentral/answers/37595-how-can-i-read-database-from-database-row-by-row

Hope that helps. Good luck.

MATLAB: Does matlab 64 bit version compatible with office 32 bit ,

64 bit applications cannot invoke 32 bit Active-X or COM components or 32 bit DLLs. This is a fundamental limitation of the MS Windows architecture (and most other operating systems that support both 32 bit and 64 bit applications.)

Best Answer

Related Solutions

MATLAB: 32-bit and 64-bit and DB issues, oh the!

MATLAB: Does matlab 64 bit version compatible with office 32 bit ,

Related Question