Re: SPSS v.27 64-bit and MS Access 32-bit?

Posted by Jon Peck on
URL: http://spssx-discussion.165.s1.nabble.com/SPSS-v-27-64-bit-and-MS-Access-32-bit-tp5740371p5740372.html

ODBC requires that the drivers match the bitness of the application.  So, with 64-bit Statistics, you would have to have 64-bit drivers.  That's not something that IBM/SPSS can fix.  One possible workaround, albeit a bit annoying, would be to export the table(s) from Access to Excel and then use the SPSS Excel import, which does not depend on ODBC, to get the data into Statistics.  This assumes that the Access databases are not too large for Excel.  Otherwise, maybe a csv export from Access would work.

On Fri, Apr 2, 2021 at 10:27 AM Ariel Barak <[hidden email]> wrote:

Hi All,

I'm currently using a 32-bit installation of SPSS v.26 on a 64-bit Windows 10 Enterprise OS with 32-bit Microsoft Office applications (Excel, Acces, etc.). I'm interested in upgrading to v.27 but now understand that it's only available as a 64-bit application. While most of the data sources I use are either SQL Server databases or Excel files, I do query a few Access databases that are 32-bit. Due to compatibility issues etc., switching these over to 64-bit MS Access is not an option.

IBM Tech Support said  "If you are upgrading to the latest version of SPSS 27, then upgrading to 64-bit applications will be necessary for compatibility to be successful." They also provided this link - https://www.ibm.com/support/pages/bit-version-and-odbc-connectivity-ibm-spss-statistics-modeler

Are folks able to use ODBC drivers querying tables from 32-bit Access databases with the 64-bit version of SPSS v.27?

Are there any simple workarounds to this bit-compatibility issue?

Does IBM expect that all SPSS users are now using 64-bit installations of MS Office products?

Any help would be greatly appreciated.

Thanks,

Ariel

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

--
===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD