Re: [R] sqlSave, fast=F option, bug?

From: Dieter Menne <>
Date: Wed 18 Oct 2006 - 15:06:01 GMT

Paul MacManus <paul.macmanus <at>> writes:

> Using the fast=F option, sqlSave saves without matching column names.
> It looks like a bug to me..........
> In other words, sqlSave didn't check column names, it simply mapped
> column 1 to column 1 and column 2 to column 2.

This seems to be a problem with SQLServer. The following example with Access works correctly for me, even if I close the connection in between. (Win2k, R 2.4.0)

Dieter Menne

channel <- odbcConnectAccess("db1.mdb")
df <- data.frame(T=1, S=10)
sqlSave(channel, df, "test", rownames=F) #odbcClose(channel)

#channel <- odbcConnectAccess("db1.mdb") df <- data.frame(S=20, T=2)
sqlSave(channel, df, "test", rownames=F, append=T,fast=T) odbcClose(channel) mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu Oct 19 01:25:49 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 19 Oct 2006 - 01:30:11 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.