On Wed, 3 Mar 2010 16:07:05 -0500, Bob Walker <
[hidden email]> wrote:
>A search of both Win7 and SPSS KB's indicates that Microsoft does not
>provide a 64-bit ODBC driver for MS Office, so at this time there is no
>resolution to this problem. So we have a 64-bit OS, and 64-bit SPSS, and no
>way to import an MS Access database. Amazing.
>
Hi
I had a look around the net too and came up with this page:
http://social.answers.microsoft.com/Forums/en-US/w7hardware/thread/001c234b-dfd5-4378-a325-c4f1482fb6fdThe final post on the above page points out that there is a 32-bit ODBC
driver with 64 bit Win 7.
I can confirm that I found the 32-bit drivers - but just for Excel, Access
and dBase (much smaller than the set of things covered in XP, but at least
it does the ones we are discussing so far). It appears then that SPSS
doesn't try to use them.
Another consequence of the inability of SPSS 18 on 64 bit Win7 to use 32 bit
drivers (or maybe it is that the 64 bit ODBC system doesn't have a subset of
32-bit drivers? Dunno) is that you can't use Export to Database either.
As someone else reported, each one of the options the Wizard offers simply
prompts you for a username and password. The "Add ODBC Source" button (which
I'd thought might provide a way of invoking the 32 bit ODBC drivers) simply
doesn't do anything.
The Help function in the Export to Database Wizard does not address any
issues such as the ones discussed here.
I imagine on the part of MS they are hoping that 64 bit versions of Office
2010 will solve the issue if they can persuade everyone to ditch their older
32 bit copies of Office. Not a 'hearts and minds' solution I venture to suggest.
I suspect it may be that both MS and SPSS need to do some work here. I may
be sticking my neck out, but given that 32 bit drivers are there, why can't
the components that import from, and export to those 32 bit Office formats
tap into the drivers where they are required?
Regards
Adrian Barnett
=====================
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
Locked
