[R] database table merging tips with R

[Thomas Lumley]

On Thu, 11 Sep 2008, Coey Minear wrote:

> Actually, based on my reading of the DBI reference, you should be able
> to do the following to create a table (although possibly not temporary):
>
>  dbWriteTable(connection, "r_user_ids", r)
>
> Then you can use the following to drop the table:
>
>  dbRemoveTable(connection, "r_user_ids")
>
> Of course, I don't know whether the ODBC driver implements these
> functions or not.  (Is 'RODBC' built on DBI?  Looks like Aaron and I
> have been assuming that.)
>

RODBC is not built on DBI, but it has analogous functions: sqlSave and sqlDrop.

     -thomas

Thomas Lumley			Assoc. Professor, Biostatistics
tlumley at u.washington.edu	University of Washington, Seattle