I've got a data.frame I'm trying to insert into a database table in an ms sql server instance using RODBC. When I save a table using nothing but character and numeric columns things work fine. However, when I attempt to add another column of type POSIXct to the data.frame and redefine the table to incorporate the new column (in the DB),attempting to push the table to the DB using sqlSave results in the following error:
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' Has anyone successfully been able to insert into a datetime field in ms sql server? If so, what type of variable did you use in R? I'm not really sure where to go or what to try next here. Any advice is appreciated. Thanks! Dave Mitchell ______________________________________________ R-help@r-project.org 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.