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? [[alternative HTML version deleted]]
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