Hi, everyone,
 
I try to run as follows:
Z>library("RODBC")
Z>cnct<-odbcConnectExcel("Forbes2000.xls")
Z>cnct
RODB Connection 1
Details:
  case=nochange
  DBQ=C:\Program Files\R\R-2.5.0\Forbes2000.xls
  DefaultDir=C:\Program Files\R\R-2.5.0
  Driver={Microsoft Excel Driver (*.xls)}
  DriverId=790
  MaxBufferSize=2048
  PageTimeout=5
Z>sqlQuery(cnct, "select * from \"Forbes2000\\$\"")
 
However, I got error like this:
[1] "[RODBC] ERROR: Could not SQLExecDirect"

[2] "42S02 -1305 [Microsoft][ODBC Excel Driver] Microsoft Jet 数据库引擎
找不到对象'Forbes2000\\$'。请确定对象是否存在，并正确地写出它的名称和路
径。"
 
I do can find Forbes2000.xls in directory, C:\Program Files\R\R-2.5.0.
Would anybody help me out?
 
Thanks for any suggestions!
_____________________________________________
Dr.Ruixin ZHU
Shanghai Center for Bioinformation Technology
rxzhu@scbit.org
zhurx@mail.sioc.ac.cn
86-21-13040647832


	[[alternative HTML version deleted]]