Given the resounding silence, I would venture to guess that no-one here is interested in troubleshooting ODBC connections to Excel. The problem is most likely in the ODBC driver for Excel (not in R or RODBC), and Excel is NOT a database (so any data format problem is unlikely to be detected). --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity.
Christofer Bogaso <bogaso.christo...@gmail.com> wrote: >Any response please? Was my question not clear to the list? Please let >me >know. > >Thanks and regards, > >---------- Forwarded message ---------- >From: Christofer Bogaso <bogaso.christo...@gmail.com> >Date: Sat, Jun 8, 2013 at 9:39 PM >Subject: Re: Problem with ODBC connection >To: r-help <r-help@r-project.org> > > >Hello All, > >My previous post remains unanswered probably because the attachment was >not >working properly. > >So I am re-posting it again. > >My problem is in reading an Excel-2003 file through ODBC connection >using >RODBC package. Let say I have this Excel file: > >http://www.2shared.com/document/HS3JeFyW/MyFile.html > > >I saved it in my "F:" drive and tried reading the contents using RODBC >connection: > >> library(RODBC) >> MyData <- sqlFetch(odbcConnectExcel("f:/MyFile.xls"), "aaaa") >> head(MyData, 30) > > >However it looks that the second column (with header 's') is not read >properly. > >Can somebody here explain this bizarre thing? Did I do something wrong >in >reading that? > >Really appreciate if someone could point out anything what might go >wrong. > >Thanks and regards, > > >On Fri, Jun 7, 2013 at 4:46 PM, Christofer Bogaso < >bogaso.christo...@gmail.com> wrote: > >> Hello again, >> >> I am having problem with ODBC connection using the RODBC package. >> >> I am basically trying to read the attached Excel-2003 file using >RODBC >> package. Here is my code: >> >> > head(sqlFetch(odbcConnectExcel("d:/ssss1.xls"), "aaaa"), 30); >> odbcCloseAll() >> Criteria s d fd f fd1 >> f1 fd2 f2 fd3 f3 F12 F13 F14 F15 F16 >F17 >> F18 F19 F20 >> 1 a NA NA NA NA 0.000000000000000000000000 >> 0.000000000000000027755576 -0.00000000000000040332321 NA NA NA >NA >> NA NA NA NA NA NA NA NA >> 2 s NA 0 NA NA 0.000000000000000000000000 >> 0.000000000000000000000000 0.00000000000000000000000 NA NA NA >NA >> NA NA NA NA NA NA NA NA >> 3 d NA 0 NA NA 0.000000000000000001734723 >> 0.000000000000000006938894 0.00000000000000002775558 5.00 NA NA >NA >> NA NA NA NA NA NA NA NA >> 4 f NA NA NA NA NA >> NA NA -4.25 NA NA NA NA NA NA NA >NA >> NA NA NA >> 5 f NA 0 NA NA 0.000000000000000000000000 >> 0.000000000000000000000000 0.00000000000000000000000 -1.53 NA NA >NA >> NA NA NA NA NA NA NA NA >> 6 f NA NA NA NA NA >> NA 0.00000000000000000000000 0.00 NA NA NA NA NA NA NA >NA >> NA NA NA >> 7 f NA NA NA NA NA >> NA 0.00000000000000000000000 NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 8 f NA 0 NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 9 f NA 0 NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 10 f NA NA NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 11 f NA NA NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 12 f NA NA NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> 13 f NA NA NA NA NA >> NA NA NA NA NA NA NA NA NA NA >NA >> NA NA NA >> >> Here you see the data in second column could not read at all. >> >> Can somebody point me if I did something wrong? >> >> Thanks and regards, >> > > [[alternative HTML version deleted]] > >______________________________________________ >R-help@r-project.org 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. ______________________________________________ R-help@r-project.org 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.