Displaying 1 result from an estimated 1 matches for "table2006".
2011 Aug 12
2
Getting data from an *.RData file into a data.frame object.
...nto a data.frame object.
Here's how I created the *.RData file.
library(RODBC)
db <- odbcConnect("*******")
df <- sqlQuery(
db
, "select * from schema.table where year(someDate)=2006"
)
save(
df
, file="C:/Documents and Settings/userName/My Documents/table2006.RData"
)
dim(df)
remove(df)
odbcClose(db)
remove(db)
detach("package:RODBC")
Next, I moved that data file (table2006.RData) to another workstation - not
at the client site.
Now, I need to get that data file into a data.frame object. I know this
should be simple, but I can't se...