2008/9/22 José E. Lozano <[EMAIL PROTECTED]>: > Recently I have been trying to open a huge database with no success. > > It's a 4GB csv plain text file with around 2000 rows and over 500,000 > columns/variables.
I wouldn't call a 4GB csv text file a 'database'. > Is there any way to work with "parts" (a set of columns) of this database, > since its impossible to manage it all at once? Yes, use a database. A real database. > Is there any way to establish a link to the csv file and to state the > columns you want to fetch every time you make an analysis? No, but you can establish a link to a database. You want a database. A real relational database. > I've been searching the net, but found little about this topic. Try: http://cran.r-project.org/doc/manuals/R-data.html#Relational-databases Barry ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.