本帖最后由 大胡子猫 于 2014-10-22 00:22 编辑
Dears~
现在加载了包RODBC，
library(RODBC)
然后尝试读取Excel文件：
channel<-odbcConnectExcel2007("d:/RLearning/RData/Salary.xlsx")
此时开始报错：
Warning messages:1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed
请问可能是因为什么原因呢？
win7 64位系统的路过....
PS，情况不太乐观，help了一下
Note: they will only work with English-language 32-bit versions of the Microsoft drivers, which may or may not be installed in other locales, and are not usable from 64-bit R. The 2007 versions work with the drivers which are installed with Office 2007/2010 and give access to formats such as ‘*.xlsx’ and ‘*.accdb’. These drivers are also available separately and there is a 64-bit version: see the package manual. (You must have the 32-bit drivers when using 32-bit R and the 64-bit drivers when using 64-bitR: otherwise there will be a cryptic message about a driver not being found. And the 64-bit drivers cannot be installed alongside 32-bit Microsoft Office, and vice versa.
|
发表于 2014-10-21 23:58:42