Displaying 20 results from an estimated 9000 matches similar to: "Creating a .txt file from an Oracle DB without creating an R object"
2007 Jul 17
4
[R-sig-DB] RODBC on Oracle DB
essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle")
> sqlTables(essai)$ORESTE
...
1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA>
1316 <NA> ORESTE S_PROVENANCES TABLE <NA>
1317 <NA> ORESTE
2003 Jul 09
2
RODBC and Oracle: error "table does not exist"
Dear r-helpers!
I have trouble reading data from an Oracle data base using
RODBC Version 1.0-3,
R Version 1.7.1,
Windows XP,
Oracle8 ODBC Driver Version 8.1.6.4.0:
> library(RODBC)
> channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE)
> # ok, this was succesful
> x <- sqlTables(channel)
> x[37, ]
TABLE_CAT TABLE_SCHEM TABLE_NAME
2005 Oct 10
3
sqlFetch on MySQL-DB
Dear all,
I successfully set up a local MySQL-database. Connecting via RODBC is
not problem, the same in fetching 3 of 4 tables. But trying to
connect to table 4 fails.
> author<-sqlFetch(test,"author")
Error in fromchar(unclass(x)) : character string is not in a standard
unambiguous format
In principle I understand that error message, but I don't know any
solution.
2002 Aug 28
1
RODBC: sqlFetch and its argument sqtable
Calling function "sqlFetch" in library(RODBC) and specifying a character
string as 2nd argument, I get an error I don't understand:
library(RODBC)
channel <- odbcConnect("mydatabase.mdb", case="msaccess")
sqlFetch(channel, "mytable")
# this works fine
tabname <- "mytable"; sqlFetch(channel, tabname)
# this gives an error:
# Error in
2009 Aug 14
1
RODBC does not like table names >11/12 characters
Hi List,
I used to access a Paradox database using RODBC, but since last week I
am not able anymore to fetch any table which has a name longer than 11
or 12 characters.
Here is the the pattern of my code, nothing spectacular:
library(RODBC)
channel2<-odbcDriverConnect('DSN=xxx')
#table names with up to 11 characters still work
sqlFetch(channel2, 'abcdefghijk')
#table names
2012 May 19
2
Loading the stupid dataset--help!!!
I am using the following:
library(RODBC)
chan = odbcConnectExcel("rats-lda")
rats.lda = sqlFetch(chan, "data")
close(chan)
And getting the following error message:
> library(RODBC)
Error in library(RODBC) : there is no package called ?RODBC?
> chan = odbcConnectExcel("rats-lda")
Error: could not find function "odbcConnectExcel"
> rats.lda =
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
I have probably an old question.
I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC
library does not work. Tried odbcConnectExcel2007 still does not work.
Any ideas.
Thanks
Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable
= "Sheet3",
+ na.strings = "NA", as.is = TRUE)
Error in
2003 Sep 23
1
RODBC access to MS-Excel (PR#4266)
Full_Name: Michael Hecht
Version: 1.7.1
OS: WinNT
Submission from: (NULL) (193.158.76.205)
I've got a problem with the RODBC library while trying to access to an MS-Excel
file. The Excel file was originally exportet by a commercial software, so I
cannot influence it. The problem is, that the names of the tables include
spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I
2003 Mar 13
2
RODBC and Excel in Widows
Hello, I have some problems with RODBC and Excel in Win98
I am using R 1.6.2 and just upgraded RODBC to the last version on CRAN.
I have an Excel file with columns Number, Name, Sex, Age, FEV1 on Sheet
1 and Number, Age, FEV1, Name, Sex on Sheet 2.
Now I open the channel to the file
> chan1 <- odbcConnectExcel("c:/testOdbc.xls")
> tables(chan1)
and the list appears with the 2
2009 Jan 31
1
FW: can't get package boot to load
Changing
library(RODBC,boot)
to
library(RODBC)
library(boot)
seems to have solved the problem.
_____
_____________________________________________
From: Gary Smith [mailto:gary.smith28 at comcast.net]
Sent: Saturday, January 31, 2009 12:55 PM
To: 'r-help at R-project.org'
Subject: can't get package boot to load
Hi,
I am new to R and I'm totally confused by this problem.
2009 Nov 18
3
Re ading multiple Excel 2007 files with a loop
I have several hundred Excel 2007 data files in a folder. I would like to
read every file in a single given folder using a loop.
I have searched the FAQ, the forum archives here, other or older R boards
and the R Import / Export documentation, and have asked some very
knowledgeable R users without learning of a solution. I hope someone here
can help.
I understand that the most common
2007 Jan 16
1
RODBC: sqlQuery is successful, but a similar sqlFetch returns error
Greetings guRus --
I have successfully queried a large (24,445 rows by 281 cols.) in-house
database using the following RODBC query (without the line breaks)
testout <- sqlQuery(channel, "select idSchedule,EXCL_Total from
dbo.vwC1198_2006_RawData_With_CMPL_EXCL")
This returns a dataframe of 24445 rows and two columns (as intended),
but the following command
testout
2011 Jul 20
1
Problem with RODBC
I have been trying to read some data from an Excel workbook without
success. The workbook is in .xls format and has multiple sheets, one
with the sheet name Data, which is the sheet I wish to read from. One
complication is that the header row of this sheet is comprised of
dropdown boxes.
I tried what I normally would do plus some variations. Here is the output.
> require(RODBC)
>
2004 Nov 11
2
RODBC & POSIX & Daylight Saving blues
Dear All,
The recent improvement in RODBC to recognize datetimes in tables has
exposed my ongoing confusion.
All my data are obtained from a satellite system (Argos) which tags events
in the GMT time zone. Daylight saving is ignored. To my way of thinking
this means that
1. twelve-o-clock means halfway through the day regardless of season, and
2. the difftime of any two dates where
2011 Apr 04
2
RODBC excel - need to preserve (or extract) numeric column names
I'm using RODBC to read an excel file (not mine!). But I'm struggling to find a way to preserve the column names that have a numeric value. sqlFetch() drops the value and calls them f1, f2, f3,... (ie field number). this is a different approach from read.csv, which will append "V" prior to the numeric column name. sqlFetch isn't so helpful.
Is there a way to get the
2004 Nov 09
1
RODBC bug or doc error in sqlFetch on xls files (PR#7354)
R 2.0.0 patched under win2000. MS Office Excel 2003. ODBC Drivers?
This may not come as a surprise -- sqlFetch() (and perhaps other ?) appear
not to handle table/worksheet names with spaces in them in Excel tables. I
was not able to find documentation that specifically mentioned this,
although the Help pages vaguely hinted that there might be difficulty with
Excel's "peculiar
2002 May 11
2
RODBC sqlFetch
Hi,
Thanks for showing me how to use RODBC and odbcConnect.
Now works nicely. The question I've got now is:
noms <- list.files(pattern=".DBF")
# removing extension names:
noms <- sapply(noms, function(x) as.character(strsplit(x,".DBF")) ,
USE.NAMES=F)
for (i in 1:length(noms)) {
s <- sqlFetch(bdades, noms[i])
# etc.
}
But it seems that sqlFetch()
2004 Nov 09
1
colnames argument in sqlFetch backwards? (PR#7355)
Full_Name: Bert Gunter
Version: 2.0.0 patched
OS: Win2000
Submission from: (NULL) (192.12.78.250)
The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to be
reversed, at least for .xls files.
## z is a connection to an xls workbook opened by odbcConnectExcel()
> dat<-sqlFetch(z,'SuccessRates',colnames=FALSE)
> dat[1:5,]
RecID Name Run Grams Lost Run
2007 Mar 06
2
Package RODBC
I have some questions about the RODBC package.
library(RODBC) # required for those who want to repeat these lines
1st, I noticed that the following sequence does not work:
channel <- odbcConnextExcel("test.xls")
tables <- sqlTables(channel)
name1 <- tables[1, "TABLE_NAME"] # this should be the name
plan1 <- sqlFetch(channel, name1) # bang!
2008 Jun 26
1
RODBC, sqlFetch error when accessing Excel
This is about R 2.7.0 and related packages on windows NT.
I have a mixture of numeric and character data and empty cells in an
Excel spreadsheet with several tabs that I'm trying to read with
sqlFetch from RODBC.
The data that is returned by sqlFetch is unfortunately not identical
to the source data in that in columns with character values in the
first few rows the subsequent rows of that