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
|