RODBC sqlSave and column names

Posted by waanders on Stack Overflow See other posts from Stack Overflow or by waanders
Published on 2010-04-08T14:20:30Z Indexed on 2010/04/08 14:23 UTC
Read the original article Hit count: 225

Filed under:

I've a question about using sqlSave. How maps 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.

© Stack Overflow or respective owner

Related posts about r