[R] RODBC-sqlSave questions

[Richard Rowe]

Please clarify the data structures and what you did and enclose the 
commands you used.

Consider testing with a small artificial dataset.

Choose your words carefully 'load' is ambiguous

Ferry wrote:
> Hello,
>
> I have 4 data frames, say A, B, C, D. Each A, B, C has different columns
> set, and D has all of what A, B, and C have.
> So, here is the example:
> A has c1, c2, and c3
> B has c4 and c5
> C has c1, c5, and c6
> D has c1, c2, c3, c4, c5, and c6.
>
> I want to load these data frames into an Oracle SQL server. I am using RODBC
> with sqlSave, and managed to load D. But when I tried to load the other data
> frames, I failed. I already use append option, but still failed.
> I've tried to rbind all frames into one set, but no success either.
>
> Any idea?
>   



-- 
Dr Richard Rowe
Zoology & Tropical Ecology
School of Marine & Tropical Biology
James Cook University
Townsville 4811
AUSTRALIA

ph +61 7 47 81 4851
fax +61 7 47 25 1570
JCU has CRICOS Provider Code 00117J