Re: [R] RODBC Access limit?

From: ONKELINX, Thierry <Thierry.ONKELINX_at_inbo.be>
Date: Thu, 03 Jul 2008 10:24:11 +0200

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

HTH, Thierry




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
Belgium
tel. + 32 54/436 185
Thierry.Onkelinx_at_inbo.be
www.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 data.
~ John Tukey

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

I have been using RODBC to connect to an Access database to capture data to
create plots. Recently I found incomplete charts. Upon investigation I discovered that the data retrieved stopped at 3276 rows (records) out of a
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:
http://www.nabble.com/RODBC-Access-limit--tp18253443p18253443.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_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.

______________________________________________
R-help_at_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.
Received on Thu 03 Jul 2008 - 09:16:25 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 03 Jul 2008 - 10:31:23 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive