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]]

