Displaying 1 result from an estimated 1 matches for "all_month".
Did you mean:
all_monthly
2002 Mar 21
0
RODBC
...9;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...