RE: [R] RODBC, sqlSave and sqlAppend

2005-03-16 Thread Matthew W Nash
] RODBC, sqlSave and sqlAppend I use RODBC all day every day and while I am pretty happy with it, I was never able to make a table separately and append to it using sqlSave. Nevertheless, maybe my observations will help. I always let sqlSave make the table for me. Make sure the table doesn't exist

Re: [R] RODBC, sqlSave and sqlAppend

2005-03-16 Thread roger bos
/ -Original Message- From: roger bos [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 19:40 To: [EMAIL PROTECTED] Cc: r-help@stat.math.ethz.ch Subject: Re: [R] RODBC, sqlSave and sqlAppend I use RODBC all day every day and while I am pretty happy with it, I was never able to make a table

[R] RODBC, sqlSave and sqlAppend

2005-03-15 Thread Matthew W Nash
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

Re: [R] RODBC, sqlSave and sqlAppend

2005-03-15 Thread roger bos
I use RODBC all day every day and while I am pretty happy with it, I was never able to make a table separately and append to it using sqlSave. Nevertheless, maybe my observations will help. I always let sqlSave make the table for me. Make sure the table doesn't exist and it will make it. I

Fwd: [R] RODBC, sqlSave and sqlAppend

2005-03-15 Thread Depiereux Constant
Début du message réexpédié : De: Depiereux Constant [EMAIL PROTECTED] Date: 16 mars 2005 00:11:11 GMT+01:00 À: [EMAIL PROTECTED] 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