[R] RODBC

[Beat Huggler]

Hi guys


I'm working with with R1.4.1 on windows

I'm trying to import data from the ODBC (Access database) with the
library RODBC. Every thing works perfect except that the dates are
factors.


> library(RODBC)
> xx  <- odbcConnect("grave_liv")
> dat <- sqlQuery(xx,"SELECT All_MONTHLY.ID, All_MONTHLY.Date,
All_MONTHLY.RoR FROM (Reasons INNER JOIN FundDet_Grave ON Reasons.Nane =
FundDet_Grave.NAME) INNER JOIN All_MONTHLY ON FundDet_Grave.REFERENCE =
All_MONTHLY.ID WHERE (((Reasons.reason)='l')) ORDER BY All_MONTHLY.ID,
All_MONTHLY.Date DESC;")
> 
> 


Know I would like to ask if anybody has an idea to change id either to a
numerical value or to a date? I've tried several things with the date
function in the library survival but nothing worked.

Thank you

Beat

---
Beat Huggler
Quantitative Analysis
RMF Investment Products
Huobstrasse 16
8808 Pfaeffikon SZ
Switzerland
www.rmf.ch
Tel. +41 55 415 87 30
Fax +41 55 415 87 07

This message and any attachment are confidential and may be privileged
or otherwise protected from disclosure.  If you are not the intended
recipient, please telephone or email the sender and delete this message
and any attachment from your system.  If you are not the intended
recipient you must not copy this message or attachment or disclose the
contents to any other person.

 
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._