[R] RODBC Access limit?

ONKELINX, Thierry Thierry.ONKELINX at inbo.be
Thu Jul 3 10:24:11 CEST 2008

Have you checked your data at row 3277? It could be that there is
something odd in that row.



ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature
and Forest
Cel biometrie, methodologie en kwaliteitszorg / Section biometrics,
methodology and quality assurance
Gaverstraat 4
9500 Geraardsbergen
tel. + 32 54/436 185
Thierry.Onkelinx op inbo.be 

To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to
say what the experiment died of.
~ Sir Ronald Aylmer Fisher

The plural of anecdote is not data.
~ Roger Brinner

The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of
~ John Tukey

-----Oorspronkelijk bericht-----
Van: r-help-bounces op r-project.org [mailto:r-help-bounces op r-project.org]
Namens HBaize
Verzonden: donderdag 3 juli 2008 9:37
Aan: r-help op r-project.org
Onderwerp: [R] RODBC Access limit?

I have been using RODBC to connect to an Access database to capture data
create plots. Recently I found incomplete charts. Upon investigation I
discovered that the data retrieved stopped at 3276 rows (records) out of
table with over 5600 records. 

I've tried changing "max","buffsize", and "rows_at_time" but it still
returns only 3276 rows.  

Is this a limitation in R or Access? Is there an easy work around? 

Thanks for any helpful suggestions.

View this message in context:
Sent from the R help mailing list archive at Nabble.com.

R-help op r-project.org mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list