Attach to SQL Server Database Tables

[MICHELLE WILSON]

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

[Rick Oliver-3]

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

[Jon K Peck]

Yes, both are possible.  You need to install the SQL Server ODBC driver from the Data Access Pack.  Then use the Database Wizard to create the code for reading and the Export to Database item for writing.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        MICHELLE WILSON <[hidden email]>
To:        [hidden email]
Date:        09/23/2014 11:33 AM
Subject:        [SPSSX-L] 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