Dear R-users,
I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under
windows.
Say I have a table "testtable" (in an Access data base) with 3 columns and 1
row that looks like this:
X Y Z
0012345 42 42,1
The columns are of these types: X - character, Y - Long Integer, Z - Decimal.
I use RODBC to get these data into R:
> library(RODBC)
> channel <- odbcConnectAccess("C:\\temp\\testdb.mdb")
> x <- sqlFetch(channel, "testtable", as.is = TRUE) # need as.is so that X
> won't be converted to numeric
> summary(x)
X Y Z
Length:1 Min. :42 Length:1
Class :character 1st Qu.:42 Class :character
Mode :character Median :42 Mode :character
Mean :42
3rd Qu.:42
Max. :42
So the problem seems to be the decimal point, as I am on an Austrian locale:
> Sys.getlocale()
[1]
"LC_COLLATE=German_Austria.1252;LC_CTYPE=German_Austria.1252;LC_MONETARY=German_Austria.1252;LC_NUMERIC=C;LC_TIME=German_Austria.1252"
I tried
> options("dec")
$dec
decimal_point
"."
> options(dec = ",")
, but that doesn't change anything.
How can I "tell" RODBC that the decimal point in my data base is ","?
Your advice would be appreciated;
kind regards
Heinrich.
______________________________________________
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.
