从锐思上下载的   


代码是  ：


install.packages("RODBC")


#注：需要先安装程序包RODBC，语句为：install.packages("RODBC")
library(RODBC)  
#将文件存储在D盘根目录下
Data1=odbcConnectExcel("C:/Users/Administrator/Desktop/rsoftware/FDNV_31AFFA093C9_(1).xls")  
FDNV_1=sqlFetch(Data1,"FDNV")
attach(FDNV_1)
infopubdt=as.Date(infopubdt,format="%Y-%m-%d")
enddt=as.Date(enddt,format="%Y-%m-%d")











提示：
> install.packages("RODBC")
--- 在此連線階段时请选用CRAN的鏡子 ---
试开URL’http://cran.nexr.com/bin/windows/contrib/3.2/RODBC_1.3-11.zip'
Content type 'application/zip' length 828578 bytes (809 KB)
downloaded 809 KB

程序包‘RODBC’打开成功，MD5和检查也通过

下载的二进制程序包在
        C:\Users\Administrator\AppData\Local\Temp\RtmpGQ31jw\downloaded_packages里
> library(RODBC)  
> Data1=odbcConnectExcel("C:/Users/Administrator/Desktop/rsoftware/FDNV_31AFFA093C9_(1).xls")  
Error in odbcConnectExcel("C:/Users/Administrator/Desktop/rsoftware/FDNV_31AFFA093C9_(1).xls") :
  odbcConnectExcel is only usable with 32-bit Windows
> FDNV_1=sqlFetch(Data1,"FDNV")
Error in inherits(channel, "RODBC") : 找不到对象'Data1'
> attach(FDNV_1)
Error in attach(FDNV_1) : 找不到对象'FDNV_1'
> infopubdt=as.Date(infopubdt,format="%Y-%m-%d")
Error in as.Date(infopubdt, format = "%Y-%m-%d") : 找不到对象'infopubdt'
> enddt=as.Date(enddt,format="%Y-%m-%d")
Error in as.Date(enddt, format = "%Y-%m-%d") : 找不到对象'enddt'
> library(RODBC)  
> #将文件存储在D盘根目录下
> Data1=odbcConnectExcel("C:/Users/Administrator/Desktop/rsoftware/FDNV_31AFFA093C9_(1).xls")  
Error in odbcConnectExcel("C:/Users/Administrator/Desktop/rsoftware/FDNV_31AFFA093C9_(1).xls") :
  odbcConnectExcel is only usable with 32-bit Windows
> FDNV_1=sqlFetch(Data1,"FDNV")
Error in inherits(channel, "RODBC") : 找不到对象'Data1'
> attach(FDNV_1)
Error in attach(FDNV_1) : 找不到对象'FDNV_1'
> infopubdt=as.Date(infopubdt,format="%Y-%m-%d")
Error in as.Date(infopubdt, format = "%Y-%m-%d") : 找不到对象'infopubdt'
> enddt=as.Date(enddt,format="%Y-%m-%d")
Error in as.Date(enddt, format = "%Y-%m-%d") : 找不到对象'enddt'
>