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 1:25 PM, Ahmed Attia <ahmedati...@gmail.com> wrote:
> I have probably an old question.
>
> I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC
> library does not work. Tried odbcConnectExcel2007 still does not work.
>
>
> Any ideas.
>
> Thanks
>
>
> Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable
> = "Sheet3",
> + na.strings = "NA", as.is = TRUE)
> Error in sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),
> :
> first argument is not an open RODBC channel
> In addition: Warning messages:
> 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
> [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
> Manager] Data source name not found and no default driver specified
> 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
> ODBC connection failed
> >
>
> Melissa<-sqlFetch(odbcConnectExcel("F:\\Cotton2012\\validation.xlsx"),sqtable
> = "Sheet3",
> + na.strings = "NA", as.is = TRUE)
> Error in odbcConnectExcel("F:\\Cotton2012\\validation.xlsx") :
> odbcConnectExcel is only usable with 32-bit Windows
>
> --
> Ahmed M. Attia
>
>
> Research Assistant
> Dept. Of Soil&Crop Sciences
> Texas A&M University
> ahmed <ahmeda...@zu.edu.eg>.at...@ag.tamu.edu
> Cell phone: 001-979-248-5215
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>
[[alternative HTML version deleted]]
______________________________________________
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.
