"Earl F. Glynn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'll try the odbcDriverConnect and let you know.
Thanks. odbcDriverConnect worked fine for me, too, with new Excel 2007
formats:
library(RODBC)
channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,
*.xlsm, *.xlsb);DBQ=G:/RODBC/TimeOrdering.xlsx; ReadOnly=True")
d <- sqlFetch(channel,"Sheet1", as.is=TRUE)
odbcClose(channel)
names(d)
I haven't checked, but the same trick is likely needed for Access 2007 using
RODBC. On Windows Vista with Office 2007, the ODBC Data Source Adminstrator
shows two drivers for Access:
Microsoft Access Driver (*.mdb)
Microsoft Access Driver (*.mdb, *.accdb).
In Access 2007, the new database extension is .accdb instead of .mdb.
efg
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
