Displaying 20 results from an estimated 2000 matches similar to: "RODBC Package"
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
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
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
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
2005 Jan 28
2
using RODBC
I am trying to bring data into R from an excel spreadsheet in order to
perform several statistical tests on it. I was trying to use
odbcConnectExcel in the RODBC package. Once I am connected to the excel
file, how do I select rows and columns from the file in order to analysis
them in R.
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
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 =
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
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
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'
2005 Jun 08
1
RODBC question: problem importing series with blank cells
Hello,
I have an excel file that I load through RODBC. Some of my columns are
blank. They are equity time series and the stocks did not exist at the
earlier dates. My problem is that the whole column becomes <NA> even though
there are numbers at later dates.
Here's my excel file
http://www.tradebit.com/download.php/35699
<http://www.tradebit.com/download.php/35699>
And
2009 Aug 13
1
using the RODBC for excel
Hi,
I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?
> connection = odbcConnectExcel('D:\\R files\\TestData.xls')
> tables = sqlTables(connection)
> tables
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 D:\\R files\\TestData <NA>
2004 Oct 25
1
.Rprofile and RODBC
Since installing R 2.0 I've had the following 2 issues
I can't find solutions for. I'm using Windows XP.
1) R 1.9 continues to read my .Rprofile file in my
home directory but R 2.0 does not. How do I get R 2.0
to do this?
2) The following function no longer works in R 2.0 but
continues to work in R 1.9:
getExcel <- function (x) {
invisible(require(RODBC))
x <-
2009 Jan 05
1
error message of RODBC...
channel <- odbcConnectExcel("nuova tabella terapia occupazionale mod.xls")
> ## list the spreadsheets
> sqlTables(channel)
TABLE_CAT
TABLE_SCHEM TABLE_NAME
1 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'emi tot 2006 OAI_60g TO FU1$'
2 c:\\TABELLE DEFINITIVE\\nuova
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 =
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"
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 =
2011 Mar 03
1
sqlFetch (RODBC) question
Dear all,
I've used RODBC a lot to read in files created in MS excel and access but
found a strange problem today: a variable in my data file contained both
numbers and text; sqlFetch would set text within a row of numbers to NA; but
if first 5 or 6 rows would be text then all numbers would be read in as NA.
con<-odbcConnectExcel("xample.xls") #the file is attached or at
2007 Dec 14
1
RJDBC to OpenOffice Calc as RODBC to MS Excel
Under Windows, I have used RODBC to connect to Excel spreadsheets as per
the example below:
library(RODBC);
connect = odbcConnectExcel("testdata.xls");
query = "SELECT [data$.ethn], [data$.sex], [data$.age],
[data$.height], [data$.weight],
[label$.label]
FROM [data$], [label$]
WHERE [data$.ethn] = [label$.ethn];"
data =
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