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

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

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