[R] Why the error is coming while extracting the data from sheet?

[Jeff Newmiller]

We cannot help you if you don't give us enough information to do so. Please use the dput function to give us a copy of your "cdb_frame" as others have already requested.

You may also find the str function helpful in diagnosing your own problems.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Sri krishna Devarayalu Balanagu <balanagudevarayulu at gvkbio.com> wrote:

>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 at 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.