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-tp5740371p5740375.html

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

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