RODBC sqlSave and column names

Question

I've a question about using sqlSave. How does R map RODBC data in the data frame to the database table columns?

If I've a table with columns X and Y and a data frame with columns X and Y, RODBC puts X into X and Y into Y (I found out by trail-and-error). But can I explicitly tell R how to map data.frame columns to database table columns, like put A in X and B in Y.

I'm rather new to R and think the RODBC manual is a bit cryptic. Nor can I find an example on the internet.

Answer 1

You should find the fine R manuals of great help as you start to explore R, and its help facilities are very good too.

If you start with

  help(sqlSave)

you will see the colNames argument. Supplying a vector c("A", "B") would put your first data.frame column into a table column A etc.

Answer 2

I'm now doing it this way (maybe that's also what you meant):

colnames(dat) <- c("A","B")
sqlSave(channel,dat,tablename="tblTest",rownames=FALSE,append=TRUE)

It works for me. Thanks for your help.