Re: Importing from MS Access (64 bit version)

Posted by Robert Walker on Oct 17, 2011; 4:33pm
URL: http://spssx-discussion.165.s1.nabble.com/Importing-from-MS-Access-64-bit-version-tp4907197p4910601.html

Hi,

Using syntax, am able to retrieve MS Access data using 64-bit drivers.

Code snippet using...

GET DATA/TYPE=ODBC/CONNECT=
  "DSN=MS Access Driver;DBQ=C:\Filename.mdb;DriverId=25;"
  "FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"

...followed by the appropriate /SQL="SELECT ..."

HTH,

Bob Walker
Surveys & Forecasts, LLC
www.safllc.com


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of drfg2008
Sent: Sunday, October 16, 2011 12:10 PM
To: [hidden email]
Subject: Importing from MS Access (64 bit version)

Someone wants to import data from MS Access into SPSS (Windows7 / 64 bit
version / SPSS 19). According to him, SPSS does not import data from MS
Access if run on a 64 bit version. SPSS message:

/If you run the Windows 64-bit version of SPSS Statistics, you can not read
Excel, Access or dBASE database sources, even if they are listed in the list
of available database sources. The 32-bit ODBC drivers for these products
are not compatible./

Is that correct?

Thanks

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Importing-from-MS-Access-64-bit-version-tp4907197p4907197.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