I do recall seeing posts on RDOM flying around from time to time and today 
have stumbled across as well through my RODBC  searches.  I have also been 
reminded from another reply of RCOM being a potential solution.  I had 
hoped to stick to more of a pure sql based process, but certainly R makes 
it easy to change course when necessary.  I shall do some digging into 
each of these packages now as well.  Thanks for the response!

--Cheers.





"James W. MacDonald" <jmacdon@med.umich.edu> 
03/13/2007 02:05 PM





To
toby_marks@americancentury.com
cc
r-help@stat.math.ethz.ch
Subject
Re: [R] RODBC Excel sqlQuery  insert into






Hi Toby,

toby_marks@americancentury.com wrote:
> I have searched the archives for using insert into to update 
spreadsheets 
> using RODBC and have come up short. So, first off, is it possible?

I don't think so. Writing to an Excel spreadsheet is probably easier 
done using the RDCOMClient package. There are some good examples of how 
to do things that come with the package. Searching the R-help archives 
should also come up with some good examples.

Best,

Jim




-- 
James W. MacDonald, M.S.
Biostatistician
Affymetrix and cDNA Microarray Core
University of Michigan Cancer Center
1500 E. Medical Center Drive
7410 CCGC
Ann Arbor MI 48109
734-647-5623


**********************************************************
Electronic Mail is not secure, may not be read every day, and should not 
be used for urgent or sensitive issues.


------------------------------------------------------------
CONFIDENTIALITY NOTICE: This electronic mail transmission (i...{{dropped}}

