Re: [R] Large data Problem

2006-11-17 Thread Roger D. Peng
For a CSV file I would use 'read.csv()'. I've compiled some notes on reading in large data frames into R at http://www.biostat.jhsph.edu/~rpeng/docs/R-large-tables.html. -roger Sumanta Basak wrote: Hi R-Experts, I'm having a problem with reading a large data file which

[R] Large data Problem

2006-11-16 Thread Sumanta Basak
Hi R-Experts, I'm having a problem with reading a large data file which is in .csv format and size is 120 MB (app.). I was trying to use RODBC package but I found RODBCconnectExcel function only. And can I convert this file to .dbf format? How can I read this file? And also let me

Re: [R] Large data Problem

2006-11-16 Thread Tim Calkins
Sumanta consider using read.csv which is a special case of read.table ?read.csv as for the RODBC functions, you probably found odbcConnectExcel, but the help file there mentions a .dbf connections ?odbcConnectDbase from there using sqlQuery it should be possible to write a .dbf file.