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? Thanks.
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
Hi All,
I'm using Microsoft Office 2007 Beta version and I have
one file in .xlsx format with size 168MB. How can I use odbcConnectExcel
in this as this function only supports .xls format? I have huge data
containing 603470 rows in a .csv file. Thanks in advance.
Sumanta Basak.
THIS COMMUNICATION DOES NOT CONSTITUTE INVESTMENT ADVICE OR COUNSEL OR
SOLICITATION FOR INVESTMENT IN ANY SECURITY.
[[alternative HTML version deleted]]