Re: Attach to SQL Server Database Tables

Posted by Rick Oliver-3 on Sep 23, 2014; 4:53pm
URL: http://spssx-discussion.165.s1.nabble.com/Attach-to-SQL-Server-Database-Tables-tp5727365p5727366.html

Yes and Yes. Look at the Database Wizard and GET DATA /TYPE=ODBC.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        MICHELLE WILSON <[hidden email]>
To:        [hidden email]
Date:        09/23/2014 11:36 AM
Subject:        Attach to SQL Server Database Tables
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hello,

I have data in a SQL Server database which is currently being exported into Excel.  

Can SPSS read data directly from a SQL Server database table?

If yes, please tell me how.

Also, is there anyway to write data directly into a SQL Server table with SPSS?

If yes, please share.

Thanks so much,
M.  Wilson
===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@... (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