Even though the sheet name Publication exists. The error is coming.
Can anyone help?


library("RODBC")
cdb_cnct <- odbcConnectExcel("Copy of 
AZIF_DC_GVK_NSCLC_MSALL_287papers_02072012_141450_v1_4.xls")
cdb_frame <- sqlFetch(cdb_cnct, "Publication")
odbcClose(cdb_cnct)

Error in odbcTableExists(channel, sqtable) :
  'Publication': table not found on channel

rm(cdb_cnct)
________________________________
Notice: The information contained in this electronic mail message is intended 
only for the use of the designated recipient. This message is privileged and 
confidential. and the property of GVK BIO or its affiliates and subsidiaries. 
If the reader of this message is not the intended recipient or an agent 
responsible for delivering it to the intended recipient, you are hereby 
notified that you have received this message in error and that any review, 
dissemination, distribution, or copying of this message is strictly prohibited. 
If you have received this communication in error, please notify us immediately 
by telephone +91-40-66929999<tel:%2B91-40-66929999> and destroy any and all 
copies of this message in your possession (whether hard copies or 
electronically stored copies).
______________________________________________
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.

Reply via email to