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

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

ariel barak
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
Reply | Threaded
Open this post in threaded view
|

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

Jon Peck
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
Reply | Threaded
Open this post in threaded view
|

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

ariel barak
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
Reply | Threaded
Open this post in threaded view
|

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

Bruce Weaver
Administrator
In reply to this post by Jon Peck
Jon, could R's ImportExport package be used to make the process a little less
hands-on?  

  https://cran.r-project.org/web/packages/ImportExport/ImportExport.pdf




Jon Peck 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.





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
Reply | Threaded
Open this post in threaded view
|

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

Jon Peck
I haven't used that R package, but it relies on ODBC, so I expect that it would encounter the same obstacles as SPSS with mixed 32/64-bit combinations.  On top of that, transferring the data on to SPSS Statistics would require further work.

I found this statement in the RODBC doc.
The Access/Excel 2010 versions at https://www.microsoft.com/en-us/download/
details.aspx?id=13255 have a 64-bit version: however the 64-bit drivers cannot be in-
stalled alongside 32-bit versions Office (as far as we know, and definitely not for Offce
2007).

On top of that I would add that you cannot have both 32- and 64-bit versions of Office installed on the same machine.

On Fri, Apr 2, 2021 at 6:29 PM Bruce Weaver <[hidden email]> wrote:
Jon, could R's ImportExport package be used to make the process a little less
hands-on? 

  https://cran.r-project.org/web/packages/ImportExport/ImportExport.pdf




Jon Peck 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.





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

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