Re: [R] RODBC problem

From: Jerome Asselin <jerome.asselin_at_crchum.qc.ca>
Date: Fri 20 Oct 2006 - 14:42:22 GMT

On Fri, 2006-10-20 at 10:25 -0400, Wensui Liu wrote:
> In a mdb table, I have a text field with values of 1, 2, .... When I
> use rodbc to read it into R, it becomes numeric. Is it a bug or
> something?

I don't think it's a bug. This behavior is documented.

See ?sqlQuery. Try the as.is=T argument.

Jerome

-- 
Jerome Asselin, M.Sc., Agent de recherche, RHCE
CHUM -- Centre de recherche
3875 rue St-Urbain, 3e etage // Montreal QC  H2W 1V1
Tel.: 514-890-8000 Poste 15914; Fax: 514-412-7106

______________________________________________
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
and provide commented, minimal, self-contained, reproducible code.
Received on Sat Oct 21 05:07:06 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 20 Oct 2006 - 19:30:11 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.