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: 252
r
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