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

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

Hi Jon,

Thanks for your response. I understand it's likely a lot of work to build and support both 32 and 64 bit versions of SPSS, but am surprised there hasn't been more push back from users. What a pain!

It looks like in Excel, there is the ability to set up an external data source connection to an Access Database (among others) and you can point it to the tables of interest in an Access Database and refresh all the tables at one time. From the Data Ribbon in Excel, select "New Query" from the "Get & Transform" sub-menu and then "From Database>From Microsoft Access Database". This may work well with smaller databases, but I'm concerned about the efficiency of it with larger ones.

I'll see how this workaround works in the weeks ahead and try to report back to the list.

Thanks,

Ariel

On Fri, Apr 2, 2021 at 12:37 PM Jon Peck <[hidden email]> wrote:

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

--

Jon K Peck
[hidden email]

===================== 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