[R] database table merging tips with R

Thomas Lumley tlumley at u.washington.edu
Fri Sep 12 06:04:47 CEST 2008

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 Lumley			Assoc. Professor, Biostatistics
tlumley at u.washington.edu	University of Washington, Seattle

More information about the R-help mailing list