Antoher non-OBDC solution is to get the information from Excel using Microsoft COM objects. Look into
1. the RDCOM package on CRAN, or 2. the rcom package, rcom_1.0-1.zip, at: http://sunsite.univie.ac.at/rcom/download/ The rcom package has a mailing list at: http://mailman.csd.univie.ac.at/pipermail/rcom-l/ On 6/16/05, John Considine <[EMAIL PROTECTED]> wrote: > Hi Vivek, > > I'm sure there must be an elegant way to interface R w ODBC connections, but > I find it simplest to create a macro in Access that exports the data (based > on a query or table) to a csv file, then use the R function read.csv() in > which you can specify header=FALSE if you wish. I've used the importData > function in S+, which can import directly from an access database, but the > two step process in R is quicker. Excel is pretty limiting if you have lots > of data. > > JC Considine > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Vivek > > Subramanian > > Sent: Thursday, 16 June 2005 19:01 > > To: ronggui; rhelp > > Subject: Re: [R] Excel files first row not being read > > > > hi, > > > > the specifications for my application call that the input file be in > > excel only in the format i previously mentioned. > > now if the approach you mention has to be used then the part of > > converting has to be done automatically. this i found to be too > > complex. > > > > an alternative to that was to use MS access databases. but again it is > > the problem of automating the conversion that is proving difficult > > > > regards and best > > vivek > > > > On 6/16/05, ronggui <[EMAIL PROTECTED]> wrote: > > > why not save the file as csv file(using the MS excel > > application) and use the read.csv function in foreign library? > > > > > > On Thu, 16 Jun 2005 15:51:22 +0530 > > > Vivek Subramanian <[EMAIL PROTECTED]> wrote: > > > > > > > hi, > > > > > > > > i am using the RODBC package to read excel files using > > > > odbcConnectExcel and susequently sqlFetch to read the > > contents of the > > > > file. > > > > > > > > the file that i use is just a matrix of numbers thats > > all. no headers > > > > and column names. what happens is that the sqlFetch is > > not reading my > > > > first row of numbers. > > > > i have tried different combinations of colnames and > > rownames logical > > > > values but that first row is not being read into my data frame. > > > > > > > > i can manually set the first row to blanks in my > > worksheet, but since > > > > this is part of larger code where a user specifies a file > > to use this > > > > method is a little clumsy. > > > > > > > > i would be grateful if you help me get around this problem. > > > > > > > > regards, > > > > vivek > > > > > > > > ______________________________________________ > > > > R-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 > > > > > > > ______________________________________________ > > R-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 > > > > ______________________________________________ > R-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 > ______________________________________________ R-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