[R] crostab qry - Too many crosstab column headers

Anders Bjørgesæter abjrges at chello.no
Tue Sep 26 15:24:09 CEST 2006


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



More information about the R-help mailing list