下载的二进制程序包在
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'
>