SPSS 64bit / MS Access 64bit export error

[chsuser]

I am trying to export records from SPSS v. 22 to an existing MS Access 2013.  Both files have identical fields.

Error message: "The selected table 'Test' contains no fields.  Select a different table."


Any else run into this problem?

[Adrian Barnett]

Make sure that SPSS and Access are both the same bit-width. That is, if you are running the 32-bit version of SPSS, Access must also be 32-bit. If one is 64-bit and the other is 32-bit, ODBC exchange between them will not work.

 

---

From: chsuser <[hidden email]>
To: [hidden email]
Sent: Saturday, 6 February 2016, 6:03
Subject: SPSS 64bit / MS Access 64bit export error

I am trying to export records from SPSS v. 22 to an existing MS Access 2013.
Both files have identical fields.

Error message: "The selected table 'Test' contains no fields.  Select a
different table."


Any else run into this problem?



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-64bit-MS-Access-64bit-export-error-tp5731452.html
Sent from the SPSSX Discussion mailing list archive at 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

[Jon Peck]

A bitness mismatch would certainly prevent ODBC from working, but I don't think that this message is caused by that.  That usually produces an "architecture mismatch" message.  Unfortunately I can't tell what the issue is here, although I have a suspicion that it has to do with access permissions.

On Fri, Feb 5, 2016 at 4:56 PM, Adrian Barnett <[hidden email]> wrote:

Make sure that SPSS and Access are both the same bit-width. That is, if you are running the 32-bit version of SPSS, Access must also be 32-bit. If one is 64-bit and the other is 32-bit, ODBC exchange between them will not work.

 

Regards,

Adrian
--
Adrian Barnett        | "It's always the trombone player"
                      | (Faye Dunaway in 'The Arrangement')
Email: [hidden email]

---

From: chsuser <[hidden email]>
To: [hidden email]
Sent: Saturday, 6 February 2016, 6:03
Subject: SPSS 64bit / MS Access 64bit export error

I am trying to export records from SPSS v. 22 to an existing MS Access 2013.
Both files have identical fields.

Error message: "The selected table 'Test' contains no fields.  Select a
different table."


Any else run into this problem?



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-64bit-MS-Access-64bit-export-error-tp5731452.html
Sent from the SPSSX Discussion mailing list archive at 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

--

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