Hi,

I was trying to read & filter records from a large file using read.csv.sql.
I was successfully able to do that with a ~1 GB file. However I get the
following error with a >2 GB file which has exactly the same structure as
the first file.

*Error in try({ : *
*  RS-DBI driver: (RS_sqlite_import: cannot open file <filename> )*

-I have checked the file permission and the file exists in the directory.
-The error comes instantly, so I am assuming its not due to memory.
-If I skip significant number of rows(using skip= statement) from the > 2GB
file, I don't get the error.

I can do a quick and dirty fix by splitting the file into two and by
performing two separate reads, but may be thats not so elegant. Can somebody
please help?

--

	[[alternative HTML version deleted]]

