From: Clark Allan <Allan_at_stats.uct.ac.za>

Date: Sat 31 Dec 2005 - 21:08:58 EST

https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Sat Dec 31 21:21:37 2005

Date: Sat 31 Dec 2005 - 21:08:58 EST

'start the connection to R

Call RInterface.StartRServer

RInterface.RRun "library(RODBC)"

RInterface.RRun "A = odbcConnectExcel('c:/TRY.xls')"

RInterface.RRun "q1 = sqlFetch(A, 'Sheet1')"

RInterface.RRun "odbcClose (A)"

Call RInterface.GetArray("q1", Range("A1"))

can anyone show me how to solve this!

wishing you all a happy new year (in advance)
/

allan

Y X1 X2 1 6 3 1 6 3 2 6 2 2 6 2 3 5 2 3 5 2 Y X1 X2 0 1 6 3 2 6 2 3 a 2 Y X1 X2 0 1 6 3 2 6 2 3 a 2 Y X1 X2 0 1 3 2 6 2 3 5 2R-help@stat.math.ethz.ch mailing list

https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Sat Dec 31 21:21:37 2005

*
This archive was generated by hypermail 2.1.8
: Fri 03 Mar 2006 - 03:41:44 EST
*