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
[EMAIL PROTECTED]       University of Washington, Seattle

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to