Hi all, When I use ODBC to manage my datasets, I have a question about sqlFetch below. It seems that my datasets have successfully been identified but the function sqlFetch get an error when I want to read the table. And below is the questionable code. Thanks for your help!
> library(RODBC) > stock<-odbcConnect("stock") > sqlTables(stock) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\DOWNLOAD\\STOCK <NA> 1990.csv TABLE <NA> 2 F:\\DOWNLOAD\\STOCK <NA> 1996.csv TABLE <NA> 3 F:\\DOWNLOAD\\STOCK <NA> 1998.csv TABLE <NA> 4 F:\\DOWNLOAD\\STOCK <NA> 1999.csv TABLE <NA> 5 F:\\DOWNLOAD\\STOCK <NA> 2000.csv TABLE <NA> 6 F:\\DOWNLOAD\\STOCK <NA> 2001.csv TABLE <NA> 7 F:\\DOWNLOAD\\STOCK <NA> 2002.csv TABLE <NA> 8 F:\\DOWNLOAD\\STOCK <NA> 2003.csv TABLE <NA> 9 F:\\DOWNLOAD\\STOCK <NA> 2004.csv TABLE <NA> 10 F:\\DOWNLOAD\\STOCK <NA> 2005.csv TABLE <NA> 11 F:\\DOWNLOAD\\STOCK <NA> 2006.csv TABLE <NA> 12 F:\\DOWNLOAD\\STOCK <NA> 2007.csv TABLE <NA> 13 F:\\DOWNLOAD\\STOCK <NA> 2008.csv TABLE <NA> 14 F:\\DOWNLOAD\\STOCK <NA> 2009.csv TABLE <NA> 15 F:\\DOWNLOAD\\STOCK <NA> 2010.csv TABLE <NA> 16 F:\\DOWNLOAD\\STOCK <NA> test.csv TABLE <NA> 17 F:\\DOWNLOAD\\STOCK <NA> test1.csv TABLE <NA> > sqlFetch(stock,"test.csv") ´íÎóÓÚodbcTableExists(channel, sqtable) : ¡®test.csv¡¯: table not found on channel [[alternative HTML version deleted]]
______________________________________________ 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.