search for: sqlappend

Hi all, I am currently trying to read, write and append data between 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...

Début du message réexpédié : > De: Depiereux Constant <constant.depiereux@aqte.be> > Date: 16 mars 2005 00:11:11 GMT+01:00 > À: spjgmwn@iop.kcl.ac.uk > Objet: Rép : [R] RODBC, sqlSave and sqlAppend > > > Le 15-mars-05, à 16:19, Matthew W Nash a écrit : > >> Hi all, >> >> I am currently trying to read, write and append data between R and MS >> access >> using the RODBC library functions. I have no problems reading in the >> data >> but...