R help - Dec 2012 - How to import the large dataset into R

HI, R Users,


I met the following problem:
I was trying to import data of one table in .accdb database into my ODBC
database for being imported into R. The table contains 1021965 records.
 I always got the following
error msg even I change the drive:

The query can not be completed. Either the size of the query
result is larger than the maximum size of a database(2GB), or there is not
enough storage space on the disk to store the query result.

Have you got some hints why it happened like this? Is it possible
that I get all data in that table in another way to be imported into R?

Thanks a lot.
Kind regards.Tammy



 		 	   		  
	[[alternative HTML version deleted]]

does anybody can help me on this?

From: metal_licaling@live.com
To: r-help@r-project.org
Subject: How to import the large dataset into R
Date: Fri, 14 Dec 2012 11:01:03 +0300





HI, R Users,


I met the following problem:
I was trying to import data of one table in .accdb database into my ODBC
database for being imported into R. The table contains 1021965 records.
 I always got the following
error msg even I change the drive:

The query can not be completed. Either the size of the query
result is larger than the maximum size of a database(2GB), or there is not
enough storage space on the disk to store the query result.

Have you got some hints why it happened like this? Is it possible
that I get all data in that table in another way to be imported into R?

Thanks a lot.
Kind regards.Tammy



 		 	   		   		 	   		  
	[[alternative HTML version deleted]]