[S] Using ODBC/SQL to import time data

Alice Ling (alice.ling@nist.gov)
Mon, 31 Aug 1998 18:39:19 -0400


I am using ODBC (SQL) to import data to S-plus V4.0R3 for Windows NT, from
MS Access 97 database files. I can get most of the data in the query, but
when I try and get time fields, the data gets lost in the translation and
the times get set to date fields and are all set to "12/30/99". Also, I
get warnings that I have duplicate column names. The query works fine
within MS Access. Has anyone had any success with this type of query?

Thanks in advance for any insight.

Here is a sample query and the resulting warning message:

> import.data(FileName = "qia",
+ FileType = "ODBC", DataFrame = "QIA",
+ OdbcSqlQuery = "SELECT [XZPROBE TEMPS HISTORY Query].XZPROBE.Time,
[XZPROBE TEMPS HISTORY Query].TEMPS.Time
+ FROM [XZPROBE TEMPS HISTORY Query];");
There is already an object with the name Time in the Column category.
Duplicate names are

WARNING: The name Time is not a valid column name (it has illegal
characters, is too long, is a duplicate, or is a reserved word), and so no
name has been given to the correspondin

-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu. To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message: unsubscribe s-news