Date: Tue, 18 Jun 2002 22:13:37 +0200
Reply-To: "Bouillon, Bernard" <BBouillon@spss.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Bouillon, Bernard" <BBouillon@spss.com>
Subject: Re: Accessing ACCESS with SPSS 11
Content-Type: text/plain; charset="us-ascii"
Hi all,
Just a notice about using ODBC to connect to an external database.
This ensure a security about some settings that are already inside the database, like formats, labels, ...
Also be aware that each file need to receive an new ODBC driver definition and that you cannot do it once for different files.
Hope this helps.
Bernie
Bernard BOUILLON
Software Technical Support Engineer
SPSS Support
.:::. ### \|/ ` ___ '
:(o o): . (o o) (o o) - (O o) -
ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--oo-
*+ 32 2 477 17 10 - + 32 2 474 03 60
*+ 32 486 03 99 74
*+ 32 2 474 03 63
* eursupport@spss.com
bbouillon@spss.com
Corporate Website : www.showcasecorp.com
www.spss.com
Answernet : http://www.spss.com/tech/answer/index.cfm
Private Website : www.snba.be
www.bbvde.be
-----Original Message-----
From: Carol Albright [mailto:calbright@VISI.COM]
Sent: Tuesday, June 18, 2002 6:07 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Accessing ACCESS with SPSS 11
Hi, Eric and list,
This is a new 'feature' as of SPSS 10. You must set up the ODBC drivers in windows -- here's the AnswerNet text. It says Excel, but the same is true for Access (so substitute "Access" wherever it says 'Excel').
source: http://www.spss.com/tech/answer/details.cfm?tech_tan_id=100007698
Solution ID: 100007698
Title:
Excel ODBC Driver prompts for Login and Password in SPSS 10.0
Description:
Q
I am using SPSS 10.0 and File->Open Database->New Query to read in data from
Excel. In SPSS 9.0, I was able to use the Excel ODBC driver to read in Excel 97/2000
data without any problems. When I read the same data in SPSS 10.0, I am
prompted for a Login ID and Password. What do I do?
A.
As of SPSS 10.0, the File->Open->Data menu will open Excel 97 and 2000 data
types. It is no longer necessary to use File->Open Database->New Query to read in
Excel 97/2000 data. If you would like to continue reading in the data using
File->Open Database->New Query, please use the ODBC Administrator to configure
a UserDSN for each data source you will be using. The steps below detail setting up
a UserDSN for one data source.
1. Locate the ODBC Administrator in your Control Panels folder. (You can also
launch the ODBC Administrator by clicking on Add Data Source in the SPSS 10
File->Open Database->New Query dialog.)
2. On the UserDSN tab, click on Add.
3. Select the Mircosoft Excel Driver and click on Finish.
4. Type a name in the Data Source Name Area to create a UserDSN. (This is the
data source name that appears in the list in the first File->Open
Database->New
Query dialog.)
5. Verify that the correct version is indicated for your Excel file.
6. Click on Select Workbook and find the path and file name of your Excel
database.
7. Click on OK to return to the ODBC Datasource Administrator.
Created on: 10/05/2001
================================
At 01:13 PM 6/18/02 +0100, Eric Tanenbaum wrote:
>I need to analyse data held in an Access dadatbase but SPSS11 insists
>that I provide a password for the database. As this didn't happen with
>SPSS 9 I am stymied. Is there a workaround (other then exporting to an
>Excel spreadsheet and then importing the .xls file)? (I am using
>Windows 2000 and ACCESS Professional XP.)
>
>Thanks
>
>Eric Tanenbaum
>Dept of Government
>University of Essex
>Colchester, Essex CO4 3SQ
>England
>(Phone: [UK] 01206-872506 or 01206-872502
> [Int'l] 44-1206-872506 or 44-1206-872502)
>
>
HTH,
Carol
-------------------------------------------------------------------------
Carol L. Albright, MS | E-Mail : calbright@visi.com
Albright Consulting | Phone : 651/699-7218
St. Paul, MN 55105 USA | Research data services
http://www.tc.umn.edu/~syzygy
-------------------------------------------------------------------------
