Problem with ODBC connection
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:<jdnewmil at 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.christofer at 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.christofer at gmail.com> Date: Sat, Jun 8, 2013 at 9:39 PM Subject: Re: Problem with ODBC connection To: r-help <r-help at 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.christofer at 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 at 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.