Displaying 1 result from an estimated 1 matches for "cdeg_ssfa_r".
2010 Feb 23
1
RODBC to import/export xls files
...but everything is related, so I don't
think it would be better to split it. Moreover, there's a lot from an
error message and dput(). I hope it won't discourage you. I believe I've
compressed it as much as possible
- to import, I do this:
con <- odbcConnectExcel("D:\\R\\cdeg_SSFA_R.xls")
cdeg <- sqlFetch(con, "cdeg")
close(con)
It works great, but is there a way without giving the sheet name (here
"cdeg")?
The thing is that I almost always have a single sheet in my xls files,
which is not really named (usually sheet1, sheet2, etc), so it would be...