[问题类型]: 程式谘询(我想用R 做某件事情，但是我不知道要怎麽用R 写出来) [软体熟悉度]: 入门(写过其他程式，只是对语法不熟悉) [问题叙述]: 最近需要读一个约2,000,000*10的data 在Microsoft Access里面 档案类型是~.mdb 试过用sqlQuery(channel, "select * from table_name") 结果出现cannot allocate vector of size XX MB 後来找到ETLUtils pkg 但在读档案时显示 read.odbc.ffdf 1..Error in as.POSIXlt.character(x, tz, ...) : character string is not in a standard unambiguous format 貌似是日期格式错误 但是不知道该如何修改 也没有相关参数设定 想请问有没有别的方法可以读入这笔资料 [程式范例]: 代码很短就直接贴了 library(RODBC) library(ETLUtils) channel <- odbcConnectAccess("Myfile.mdb") Ldata <- read.odbc.ffdf( query = "select * from mytable_name", VERBOSE = TRUE) [环境叙述]: R version 3.2.1 (2015-06-18) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 8 x64 (build 9200) locale: [1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 [2] LC_CTYPE=Chinese (Traditional)_Taiwan.950 [3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 [4] LC_NUMERIC=C [5] LC_TIME=Chinese (Traditional)_Taiwan.950 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] ETLUtils_1.3 ff_2.2-13 bit_1.1-12 bigmemory.sri_0.1.3 loaded via a namespace (and not attached): [1] tools_3.2.1 [关键字]: ETLUtils, RODBC --

※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 122.146.71.36 ※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1441264078.A.C24.html