Anders Bjørgesæter
2006-Sep-26 13:24 UTC
[R] crostab qry - Too many crosstab column headers
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