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.