Displaying 20 results from an estimated 5000 matches similar to: "using RODBC"
2005 Jan 25
1
r square values for independent variables in multiple linear regr ession model -- newbie
Hello
Could you please suggest a way to find out the r square values for each
independent variable while using "lm" for developing a multiple linear
regression model.
Thank you
avneet
"I have no data yet. It is a capital mistake to theorize before one has
data. Insensibly one begins to twist facts to suit theories instead of
theories to suit facts."
~ Sir Arthur Conan Doyle
2005 Apr 19
1
Package 'R2HTML'
I recently learnt how to use Sweave which is a wonderful tool
After which i also tried to use R2HTML as it would allow many of my
colleagues who dont use latex to be able to use and edit my work. I was
unable to make it work and couldnt find a way to implement it. I got some
errors.
I wonder if you could help me with it
i have a windows 2000 OS and the version of R is "R version 1.9.1,
2005 Feb 07
5
Creating a correlation Matrix
Hi all:
I have a question on how to go about creating a correlation matrix. I have
a huge amount of data....21 variables for 3471 times. I want to see how
each of the variables correlate to each other. Any help would be
appreciated, including which package and which functions I should use to do
this.
Thanks,
Jessica Higgs
Masters Student
Department of Meteorology
Penn State University
2005 Mar 11
2
RODBC Package
Hello R-Help,
is there any way of using the RODBC Package on a Mac OS X
System? If yes, what do I need to get it running. Concerning these
issues, I am pretty unexperienced, so please state any step
necessary. The actual problem is accessing data in Excel- files.
(unfortunately no alternative way of entering the data).
I already installed the Package, but it says the following:
> versuch
2004 Dec 04
9
Excel *.xls files, RODBC
I gather from reading the back-issues of r-help that it should be
possible (modulo a number of caveats) to read an excel (yuck!) file
into R using RODBC. I have obtained and installed ODBC and the RODBC
package, but cannot for the life of me figure out how to go about
it. Can anyone give me a simple recipe?
I have an excel file on cdrom, say:
/mnt/cdrom/melvin.xls
I have started R and loaded
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following:
library(RODBC)
> channel <- odbcConnectExcel("results.xlsx")
Error in odbcConnectExcel("results.xlsx") :
odbcConnectExcel is only usable with 32-bit Windows # ok this is
clear why it doesn't work
> channel
2009 Apr 07
4
Re ading Excel 5.0 files with RODBC?
Hi,
i'm trying to read some data from excel files but it seems that neither
xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0).
When i open the file in Excel and save it in a new format Excel 97 -2003
everything works fine.
Is it possible to use ODBC connection to open old format files, or i guess i
will have to open and save every file in Excel in new format, which
2003 Jul 21
1
RODBC: problem saving a new table in an "Excel database"
Hi
I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows
XP Pro. I am having problems writing a new table to an (Excel) database
using sqlSave.
I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I
believe, uses the Microsoft Excel Driver DSN). Then I try and save a new
table to the database(spreadsheet) using SqlSave, but obtain an error
message.
Below is
2008 Apr 04
1
RODBC / odbcConnectExcel Issue
Can someone throw light on the following problem I am having with RODBC?
There's an Excel file I am trying to read from, it has one sheet named
'nameclass'.
Thanks in anticipation.
Vishal Belsare
> library(RODBC)
> con = odbcConnectExcel(file.choose())
> tbls <- sqlTables(con)
> tbls
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1
2007 May 24
1
"[RODBC] ERROR: Could not SQLExecDirect"
Hi, everyone,
I try to run as follows:
Z>library("RODBC")
Z>cnct<-odbcConnectExcel("Forbes2000.xls")
Z>cnct
RODB Connection 1
Details:
case=nochange
DBQ=C:\Program Files\R\R-2.5.0\Forbes2000.xls
DefaultDir=C:\Program Files\R\R-2.5.0
Driver={Microsoft Excel Driver (*.xls)}
DriverId=790
MaxBufferSize=2048
PageTimeout=5
Z>sqlQuery(cnct, "select
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
2005 Dec 31
1
r: RODBC QUESTION
hello all
i have a quick question. i have been using the RODBC library (trying to
read Excel data
into R but i am doing this by using Rexcel. this is probably not the
correct forum -
sorry for this).
my code is shown below:
Sub A()
'start the connection to R
Call RInterface.StartRServer
RInterface.RRun "library(RODBC)"
RInterface.RRun "A =
2009 Jun 25
1
RODBC 1.2-6 on CRAN, future directions
Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many
workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server
2008, Oracle and DB2.
More visibly, the documentation has been expanded in several ways, in
particular in collecting together advice on using 'schemas' and 'catalogs' in
the ?RODBC overview.
There is also a test
2009 Jun 25
1
RODBC 1.2-6 on CRAN, future directions
Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many
workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server
2008, Oracle and DB2.
More visibly, the documentation has been expanded in several ways, in
particular in collecting together advice on using 'schemas' and 'catalogs' in
the ?RODBC overview.
There is also a test
2010 Feb 23
1
RODBC to import/export xls files
Dear R users,
I've learned today about RODBC package in order to import xls file to
dataframes and export the dataframes to xls files.
However I have some problems. Please excuse me if these are basic but as
I said, I've just begun with this package.
Also this email is quite long, but everything is related, so I don't
think it would be better to split it. Moreover, there's a
2005 Nov 02
2
RODBC and Excel: Wrong Data Type Assumed on Import
The first column in my Excel sheet has mostly numbers but I need to treat it
as character data:
> library(RODBC)
> channel <- odbcConnectExcel("U:/efg/lab/R/Plasmid/construct list.xls")
> plasmid <- sqlFetch(channel,"Sheet1", as.is=TRUE)
> odbcClose(channel)
> names(plasmid)
[1] "Plasmid Number" "Plasmid"
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!
2005 Apr 20
2
problem with RODBC
Dear all,
I'm reading data via the RODBC connection using
odbcConnectExcel. I use sqlFetch(channel, "sheetx") to
identify the correct tab. It appears to read the data
without any problems. However, when I exact a portion
of data - the row number specified is 1 less than in
the actual excel file and it can't read any columns
after the 94th column.
Can someone help me? TIA
Dave
2006 Jul 12
1
RODBC, missing values, and Excel
Hi, all,
I'm trying to use RODBC to read data from Excel. However, I'm having
trouble converting missing values to NA and rather perplexed by the
output. Below illustrates my problem:
## DATA - copy to Excel and save as "tmp.xls"
## tmp.xls!Sheet1
x
0.11
0.11
na
na
na
0.11
## tmp.xls!Sheet2
x
0.11
0.11
na
na
na
na
0.11
## R Code
read.xls <- function(file, sheet =
2010 Aug 04
1
Question regarding S4 objects and reading in excel data with RODBC
L.S.
I am trying to get data from an excel sheet using the RODBC library, quite
like the example on page 34 of the 'Data manipulation with R' book written
by Phil Spector. It seems very straightforward, yet I get the same error
everytime I try it, with different excel sheets and trying to tweek the code
a bit. This is what I do:
library(RODBC)
sheet='X:\\example.xls'