Re: [R] Importing data by odbcConnectExcel in 64 bit

2013-07-16 Thread Peter Alspach
Tena koe Perhaps the help file will give you some ideas: "odbcConnectAccess, odbcConnectDbase and odbcConnectExcel are convenience wrappers to generate connection strings for those file types. The files given can be relative to the R working directory or absolute paths (and it seems also relat

Re: [R] Importing data by odbcConnectExcel in 64 bit

2013-07-16 Thread Adams, Jean
Can't help you with the odbcConnectExcel, but I can suggest an alternative ... loadWorkbook() and readWorksheet() in the XLConnect package work on Windows 7 64-bit. library(XLConnect) wb <- loadWorkbook("C:/Temp/Mydata.xlsx") dat <- readWorksheet(wb, sheet="Sheet1") Jean On Tue, Jul 16, 2013 at