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.
