search for: treatlist

...n R and MS access using the RODBC library functions. I have no problems reading in the data but when using sqlSave and sqlAppend it doesn't seem to work. I have made sure that all the column names are sensible and there are no gaps etc in the variables. My call looks like this: sqlSave(channel,treatlist,test=F) I've played with various options but what consistently happens is that R writes a new table (column names a written and sensible variable types are assigned), but it doesn't actually write any data into it. When I run sqlAppend there are no error messages, but when I look at the MS...

...ng in the >> data >> but when using sqlSave and sqlAppend it doesn't seem to work. I have >> made >> sure that all the column names are sensible and there are no gaps etc >> in the >> variables. My call looks like this: >> >> sqlSave(channel,treatlist,test=F) >> >> I've played with various options but what consistently happens is >> that R >> writes a new table (column names a written and sensible variable >> types are >> assigned), but it doesn't actually write any data into it. When I run >&gt...