Displaying 20 results from an estimated 110 matches similar to: "Exporting a dataframe from R to Excel"
2011 Aug 08
2
RODBC: sqlUpdate doesn't handle properly POSIXct field?
Hello all!
Can someone confirm whether there is a bug or not?
I was trying to use sqlUpdate in place of sqlSave as data set I import has duplications. However I get errors while using fast=FALSE argument to safely update/ignore duplicates:
Error while executing the query[RODBC] ERROR: Could not SQLExecDirect 'UPDATE "data" SET "logger"=1,
2010 Feb 03
2
sqlUpdate RODBC
Dear all,
I using R version 2.9.0 on Windows XP and want to insert data from a data
frame in R into a oracle database via sqlUpdate with the package RODBC.
My example is the following:
TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"),
DATUM=c("2009-01-01","2010-01-02","2010-06-09"))
If I create the table in the database with
2010 Nov 25
1
RODBC
Hi,
I am running the RODBC examples form the help guide. I am trying to
UPDATE a table in an Access data base but I am having an error.
library(RODBC)
library(termstrc)
path = getwd()
setwd(getwd())
dbName = "data.mdb"
pathdbname = paste(path,"/",dbName,sep="")
accesChannel = odbcConnectAccess(pathdbname, uid = "", pwd = "")
2019 Apr 16
3
PROBLEMAS NOMBRES DE COLUMNAS CON ESPACIOS CONEXION R-SQL
Buenas tardes,
Estoy tratando de realizar un update en SQL desde R:
sqlUpdate(conexion1, data.frame(AUXILIAR), tablename = "AUXILIAR")
y me devuelve el siguiente error:
*Error in sqlUpdate(conexion1, data.frame(AUXILIAR), tablename =
"AUXILIAR", : *
* data frame column(s) Corteoptimo Cortediario not in database table*
El problema es que sí existen esas columnas en SQL pero
2017 Apr 17
4
Error en sql UpDate
Buenos días, al querer actualizar los datos de una tabla en SQL SERVER
sale el siguiente error:
Error in sqlUpdate(canal_conexion, Datos, tablename =
"Tabla_SQL_SERVER_Actualizar", :
[RODBC] Failed exec in Update22018 0 [Microsoft][ODBC SQL Server
Driver]Invalid character value for cast specification
Gracias desde ya por la ayuda.
--
[[alternative HTML version deleted]]
2011 May 02
2
INSERT OR UPDATE
I'm trying to insert rows of a data.frame into a database table, or update where the key fields of a record already exist in the table. I've come up with a possible solution below, but would like to hear if anyone has a better solution.
# The problem demonstrated:
# Create a data.frame with test values
library(RODBC)
tbl <- data.frame(
key1 = rep(1:3, each = 2),
key2 =
2007 Nov 07
1
Dealing with schema in RODBC
Is there a way to get a table in a certain schema? The Oracle database I am
using has a table by the same name in two different schemas. This creates
problems in sqlUpdate because to sqlUpdate there are duplicate columns. The
following is part of the output of sqlColumns:
sqlColumns(eids, "TEST_ARTCL_INST")[,1:4]
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME
1
2011 May 04
1
tryCatch?
I would like to do inserts into a database table, but do updates in the fairly rare cases in which the inserts fail. I thought tryCatch might be the way to do it, but I honestly do not understand the help file for tryCatch at all.
I thought something like this might work:
for (i in seq(along = tbl$key)) {
tryCatch(sqlSave(pg, tbl[i, ], "tbl", append = TRUE, rownames = FALSE),
2009 May 09
1
sqlSave()
Hi all: I have created a MS Access table named 'PredictedValues' through the statement below:
myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond Farming.mdb",uid="admin",pwd="")
sqlSave(myDB,PredictedValues,rownames=FALSE)
close(myDB)
But if I run the code again with new values I get the message below:
Error in sqlSave(myDB,
2006 May 19
4
Fast update of a lot of records in a database?
We have a PostgreSQL table with about 400000 records in it. Using
either RODBC or RdbiPgSQL, what is the fastest way to update one (or a
few) column(s) in a large collection of records? Currently we're
sending sql like
BEGIN
UPDATE table SET col1=value WHERE id=id
(repeated thousands of times for different ids)
COMMIT
and this takes hours to complete. Surely there must be a quicker
2006 Jan 26
3
How do you convert this from S Plus to R - any help appreciated . thanks
exportData(MU.Cost,paste("C:/RAUDSL/S",as.character(MU.Cost$Run.Id[1]),"
.",as.character(MU.Cost$MU.Id[1]),".MU.PRICE.OUTPUT.txt",sep=""),append
= FALSE,type="ASCII",quote=FALSE)
[[alternative HTML version deleted]]
2011 May 16
2
File to MYSQL
Dear R-user,
I have to feed my database using some SQL commands. I have already read a
data frame with the data I need but
after that these data should be write in a file wtih SQL commands.
1) My dataframe:
dput(Alldados)
structure(list(Station_NO = c(836490, 836920, 836950, 836980,
837380, 837460), TMAX_2M = c("NULL", "NULL", "NULL", "NULL",
2014 Dec 05
0
Samba share over a /net automount shows only 1 entry per directory when connecting to a RHEL NFS export
I have very large samba installations running off Solaris 10u11 - very stable - and AD integrated with the OS.
A new problem has arisen I hope someone can shed light one when accessing autmounted /net host directories. Running Samba 3.6.24 on Solaris 10u11 x86
Server A?? hosts logs files and can nfs mount other servers to consume their logs via the automount /net path. Users want to read the
2011 Dec 13
0
rodbc -- save result to a table
Hi All,
I am pretty new for RODBC. I want to save my table to a DB, so I used something like
sqlSave(db, a, 'Forecast_Result', rownames = FALSE);
But I got an error
Error in sqlSave(db, a, "Forecast_Result", rownames = FALSE) :
table 'Forecast_Result' already exists
Yes, that table has been created before. But I need to overwrite the content in that
2008 Apr 08
1
Weibull maximum likelihood estimates for censored data
Hello!
I have a matrix with data and a column indicating whether it is censored
or not. Is there a way to apply weibull and exponential maximum
likelihood estimation directly on the censored data, like in the paper:
Backtesting Value-at-Risk: A Duration-Based Approach, P Chrisoffersen
and D Pelletier (October 2003) page 8?
The problem is that if I type out the code as below the likelihood
2003 Sep 07
0
AV messages and the digest
Below is the topic list for the latest digest form of the mailing list.
See if you can pick out the real messages from the myriad of warnings.
:-(
Today's Topics:
1. Autoreply to Thank you! (helpdesk@cdfreaks.com)
2. Symantec AVF detected an unrepairable virus in a message you
sent (Administrator@fai.ie)
3. Re: Runaway SMBD process (Gerald (Jerry) Carter)
4. Re: Your
2012 Nov 14
0
Write to MS SQL Database
I want to update a column of a database table (in MS SQL) using sqlUpdate( )
or sqlSave( ) function in "RODBC" package. E.g. SQLchannel is the database
connection; SQLtable is the destination table in the database, including at
least two columns, ID and Value; Xdata is a data frame in R environment,
including two columns: ID and Value. What I wanna do is to update the Value
in SQLtable
2010 Feb 10
0
RODBC Update image file into a MS-SQL database table
Hi,
I am creating some graphs which I want to update into a database table.
The procedure I am following is:
1. create the graphs as a png/jpeg file.
2. Read that file as a binary vector
3. sqlUpdate
My code:
pngfile <- file(<filename>, "rb")
N <- 1e6
repeat{
pngfilecontents <- readBin(pngfile, what="raw", n=N)
if(length(pngfilecontents) ==
2004 Sep 15
0
RODBC 1.1-1
The first non-maintenance update of RODBC since January 2003 is now on
CRAN and will soon propagate to mirrors. From the ChangeLog:
* Select the decimal point from Sys.localeconv.
* Add an external reference and finalizer so open channels get
closed at the end of the session or when there is no R object
referring to them.
* There is no longer a
2004 Sep 15
0
RODBC 1.1-1
The first non-maintenance update of RODBC since January 2003 is now on
CRAN and will soon propagate to mirrors. From the ChangeLog:
* Select the decimal point from Sys.localeconv.
* Add an external reference and finalizer so open channels get
closed at the end of the session or when there is no R object
referring to them.
* There is no longer a