[R] crostab qry - Too many crosstab column headers

From: Anders Bjørgesæter <abjrges_at_chello.no>
Date: Tue 26 Sep 2006 - 13:24:09 GMT


Hello

I guess not, but is there a way to reduce/split up a MS-access crosstab query resulting in more than 256 cols. by using sqlGetResults in RODBC to e.g. produce several dataframes of < 256 columns (that is without changing the query itself).

---

[1] "[RODBC] ERROR: Could not SQLExecDirect"

[2] "S1001 -1040 [Microsoft][ODBC Microsoft Access Driver] Too many
crosstab column headers (2270)." R - 2.3 WinXp with Ms access 2002 Best Regards Anders ______________________________________________ R-help@stat.math.ethz.ch 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 Tue Sep 26 23:26:11 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 26 Sep 2006 - 14:30:06 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.