s-news
[Top] [All Lists]

exporting data directly to SQL Server

To: "'s-news@lists.biostat.wustl.edu'" <s-news@lists.biostat.wustl.edu>
Subject: exporting data directly to SQL Server
From: "Bos, Roger" <BosR@ny.rothinc.com>
Date: Wed, 10 Nov 2004 18:27:02 -0500
I am using the  Splus "exportData" command to export data directly to a SQL
Server 2000 database.  One of the fields is a datetime datatype.  No matter
how I try to format the datetime variable in the Splus matrix, when I import
it into the database, it date is not correct.  Does anyone have an example
that works?

Also, it seems that Splus locks the table.  Does exportData have a close
connection property?

Thanks,

Roger



********************************************************************** * This 
message is for the named person's use only. It may 
contain confidential, proprietary or legally privileged 
information. No right to confidential or privileged treatment 
of this message is waived or lost by any error in 
transmission. If you have received this message in error, 
please immediately notify the sender by e-mail, 
delete the message and all copies from your system and destroy 
any hard copies. You must not, directly or indirectly, use, 
disclose, distribute, print or copy any part of this message 
if you are not the intended recipient. 
**********************************************************************

<Prev in Thread] Current Thread [Next in Thread>
  • exporting data directly to SQL Server, Bos, Roger <=