Re: [R] sqlFetch (RODBC) question

2011-03-03 Thread Ista Zahn
Hi Kenn, This is discussed in the package vignette, section 7. Best, Ista On Thu, Mar 3, 2011 at 2:55 PM, Kenn Konstabel wrote: > Dear all, > > I've used RODBC a lot to read in files created in MS excel and access but > found a strange problem today: a variable in my data file contained both > nu

[R] sqlFetch (RODBC) question

2011-03-03 Thread Kenn Konstabel
Dear all, I've used RODBC a lot to read in files created in MS excel and access but found a strange problem today: a variable in my data file contained both numbers and text; sqlFetch would set text within a row of numbers to NA; but if first 5 or 6 rows would be text then all numbers would be rea