[R] Reading Text Files with RODBC

Nutter, Benjamin NutterB at ccf.org
Thu Feb 16 16:12:56 CET 2012

I'm thoroughly stumped.  I've been playing with RODBC and wanted to see if I could retrieve data from text files using this package as well (for the most part, this is an intellectual exercise, but occasionally I do get data files large enough in CSV format RODBC could be helpful) .

I set up a DNS called "Text Files" and then ran the following code in R 

> library(RODBC)
> mtg <- odbcConnect("Text Files")
> sqlTables(mtg)
                         TABLE_CAT TABLE_SCHEM    TABLE_NAME  TABLE_TYPE        REMARKS
1 C:\\USERS\\NUTTERB                   <NA>    Core2012.txt              TABLE                 <NA>
2 C:\\USERS\\NUTTERB                   <NA> MTGCards.csv              TABLE                 <NA>
> sqlFetch(mtg, "MTGCards.csv")
Error in odbcTableExists(channel, sqtable) : 
  'MTGCards.csv': table not found on channel

MTGCards.csv is an export from an MS Access database, and I'm able to get it out of Access, and I'm also able to connect to our Oracle databases.  So I'm not sure what it is I'm not getting about reading the text files.  If anyone has done this successfully and has any pointers, I'd appreciate it.  So far I've not been able to solve it with documentation from RODBC, RStudio (I get the same error messages when I use the RGui), or Microsoft ODBC drivers.

Windows 7, 32 bit
R 2.14.1
RODBC 1.3-4
RStudio Version 3

  Benjamin Nutter |  Biostatistician     |  Quantitative Health Sciences
  Cleveland Clinic    |  9500 Euclid Ave.  |  Cleveland, OH 44195  | (216) 445-1365


 Please consider the environment before printing this e-mail

Cleveland Clinic is ranked one of the top hospitals
in America by U.S.News & World Report (2010).  
Visit us online at http://www.clevelandclinic.org for
a complete listing of our services, staff and

Confidentiality Note:  This message is intended for use
only by the individual or entity to which it is addressed
and may contain information that is privileged,
confidential, and exempt from disclosure under applicable
law.  If the reader of this message is not the intended
recipient or the employee or agent responsible for
delivering the message to the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If
you have received this communication in error,  please
contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy.  Thank you.

More information about the R-help mailing list