importing data from Excel using RODBC

Hi,
I used RODBC to import data from an Excel spreadsheet "*.xls", but some
columns were returned as zeros. When I looked at these columns in Excel, I
found that thery are results of formula calculations and not entry. My
question is: Is there any parameter or command I need to use in order to
overcome this problem?

Thank you
Ahmad Abu Hammour

use the mouse to copy the cells/sheet of interest ... move to a new sheet 
then <right click>, choose 'paste special', activate the 'values' button, 
then paste.

Use this static sheet in your RODBC connection.

Excel formulae are stored elsewhere and, so far as I know, aren't visible 
to SQL,


Richard Rowe
Senior Lecturer
Department of Zoology and Tropical Ecology, James Cook University
Townsville, Queensland 4811, Australia
fax (61)7 47 25 1570
phone (61)7 47 81 4851
e-mail: Richard.Rowe at jcu.edu.au
http://www.jcu.edu.au/school/tbiol/zoology/homepage.html

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._