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:<jdnew...@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 <balanagudevaray...@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@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. ______________________________________________ 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.