IBM Support

ODBC driver 64 bit asks for userid/passwd

Technote (troubleshooting)


You have a problem in the export database wizard when trying to export to a Microsoft Excel ODBC Data Source. It asks for a login ID and password. You have office package 32 bit installed on the 64 bit machine.
You're using the IBM SPSS Statistics 64 bit version and Windows 7 Professional (64 bit).


A 64-bit application (e.g. IBM SPSS Statistics 64-bit) cannot use a 32-bit ODBC driver (e.g. Microsoft Office 32-bit Access or Excel ODBC driver).


Windows 64 bit

Resolving the problem

When you installed the Microsoft Office 32 bit version and the IBM SPSS Statistics 64 bit version you created an incompatible situation. One solution will be to install and use the Microsoft Office 64 bit ODBC drivers.

The 64-bit ODBC drivers can be downloaded from following link :

(Microsoft Access Database Engine 2010 Redistributable)

Alternatively, you could uninstall the IBM SPSS Statistics 64-bit application and install the 32-bit version instead. However this approach defeats the purpose of deploying to a 64-bit Windows environment in the first place.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics
Statistics Desktop

Software version: 19.0, 20.0, 21.0, 22.0

Operating system(s): Windows

Reference #: 1591663

Modified date: 07 September 2016

Translate this page: