Hi Mark,
Thanks a lot!
Before getting your suggestion, I was using a for loop to paste my data
as values, and using dbUpdate to insert the data row by row.
Obviously, your solution is much faster, and need little lines of code!
Excellent!
I will file to the creator of RJDBC the bug!

Best Regards!

Huidong

On Sat, Jun 8, 2013 at 7:57 AM, Mark Rotteveel <mark@...> wrote:

> **
>
>
> On 8-6-2013 07:52, Mark Rotteveel wrote:
> > 2) First execute dbWriteTable as normal to create the database (+ get
> > the error) and then append the data
> > dbWriteTable(conn, "Tab_0", Tab)
> > dbWriteTable(conn, "Tab_0", Tab, overwrite=FALSE, append=TRUE)
>
> Obviously, the above should have been "... to create the table ...".
>
> Mark
>
> --
> Mark Rotteveel
>
>
>



--
Huidong Tian
Cancer Registry of Norway.
Phone: +47 40624112
Email: tienhuitung@...


[Non-text portions of this message have been removed]