Hello,
Thank you all for this excellent feedback.
We have several programs developed in which SPSS is importing and exporting data directly from and to Access and SQL Server tables. So I think that we are going to uninstall the 64 bit version of SPSS and install the 32 bit version instead.
The machine running spss has a 64 bit processor.
If anyone anticipates that there might be issues with this solution, I would welcome the heads up.
Thanks,Michelle
Date: Tue, 24 Feb 2015 23:08:34 +0000
From:
[hidden email]Subject: Re: SPSS 64bit / MS Access 32bit Driver incompatibility
To:
[hidden email]Hi MicheleIf you are going to try to transfer between SPSS and Access using ODBC (which the built-in drivers are), the applications concerned have to be the same bit-width at each end. That is, if you have 32-bit Access, you need 32-bit SPSS; similarly, the 64-bit versions will only talk to other 64-bit applications.
So you will need to swap one or other of SPSS or Access to match.
If that is not possible in your circumstances, you will have to transfer in other ways - e.g. export as a .csv and import that. Or use some third-party converter like StatTransfer to do the conversion between .sav and .accdb/.mdb (which is probably no more convenient than exporting in one of the intermediate formats like .csv) Regards,
Adrian
--
Adrian Barnett | "It's always the trombone player"
| (Faye Dunaway in 'The Arrangement')
Email:
[hidden email] From: MICHELLE WILSON <
[hidden email]>
To:
[hidden email]
Sent: Wednesday, 25 February 2015, 6:44
Subject: SPSS 64bit / MS Access 32bit Driver incompatibility
Hello,
I am using the 64 bit SPSS v22. I am trying to use the Export to Database feature send my dataset to a table within my 32 bit version of MS Access.
The error message that I receive is ..........
Driver's ConfigDSN,
ConfigDriver, or ConfigTranslator failed
Errors Found:
The specified DSN contains an architecture mismatch between the Driver and
Application.
How can I resolve this?
Thanks,Michelle
=====================
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
=====================
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