Displaying 1 result from an estimated 1 matches for "grave_liv".
2002 Mar 21
0
RODBC
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_MONTHL...