我想用R来连接Excel,用odbcConnectExcel来做的,程序如下:
sheet<-'D:\\projcect\\renew\\a.xls'
con<-odbcConnectExcel(sheet)
tb<-sqlTables(con)
qry<-paste("select member_id from ",tb$TABLE_NAME,"where member_t='p'")
会有如下错误:
qry
[1] "42000 -3506 [Microsoft][ODBC Excel Driver] FROM 子句语法错误。"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'select member_id from a$ where member_t='p''"
请问哪位大侠做过这个相关的,请指点下。先谢谢了!