Ah, yes. If you can't find the answer to your question, ask a different question!
sqldf does, indeed, do what I want. Thank you Benjamin Nutter | Biostatistician | Quantitative Health Sciences Cleveland Clinic | 9500 Euclid Ave. | Cleveland, OH 44195 | (216) 445-1365 -----Original Message----- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: Thursday, February 16, 2012 1:15 PM To: Nutter, Benjamin Cc: r-help@r-project.org Subject: Re: [R] Reading Text Files with RODBC On Thu, Feb 16, 2012 at 10:12 AM, Nutter, Benjamin <nutt...@ccf.org> wrote: > 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. > This isn't precisely what you are asking for but if the idea is to apply an sql statement to a csv file then read.csv.sql in the sqldf package can apply an sql statement to a csv file reading the result into R. If you omit the sql statement then it reads it all in. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com =================================== 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 locations. Confidentiality Note: This message is intended for use\...{{dropped:13}} ______________________________________________ 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.
