Hello,

How can I tell RODBC to scan all the records of an xls file to determine the 
data type? If the first n records happen to be empty Rodbc assumes a character, 
and any numbers are made <NA>. And if, for instance, the first n records contain 
numbers, and later they also contain characters, those characters  become NA.

 Cheers!!
Albert-Jan


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public 
order, irrigation, roads, a fresh water system, and public health, what have the 
Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

	[[alternative HTML version deleted]]

