Displaying 20 results from an estimated 1000 matches similar to: "Problem with sqlSave"
2009 Nov 16
3
Error on reading an excel file
Hello everybody, here is the code I use to read an excel file containing two
rows, one of date, the other of prices:
library(RODBC)
z <- odbcConnectExcel("SPX_HistoricalData.xls")
datas <- sqlFetch(z,"Sheet1")
close(z)
It works pretty well but the only thing is that the datas stop at row 7530
and I don?t know why datas is a data frame that contains 7531 rows with the
2009 Nov 18
1
Creating an excel file and manipulating it from R
Hello everybody, I?ve been looking for a function that would create an excel
file in my working directory where I would write my dataframe but I only
found the functions to write or read in an existing file that you gave me on
my former post or on some websites. I can?t find either functions to
manipulate those datas: for example, I would like some lines to be red or
green according to their
2009 Nov 16
5
Writing a data frame in an excel file
Hello, I am having trouble by using the write.table function to write a data
frame of 4 columns and 7530 rows. I don?t know if I should just use a
sep="\n" and change the .xls file into a .csv file. Thanks in advance
-----
Anna Lippel
new in R so be careful I should be asking a loooooooot of questions!:teeth:
--
View this message in context:
2009 Nov 20
2
Problem at adding lines on a graphics with lines() function
Hello, I am trying to plot a graphic with many lines with the following
command:
plot(datas[1:n,1],datas[1:n,2],type="l",main="SP500 Prices and Moving
Averages",xlab="Date",ylab="Prices",col="black")
lines(datas[1:n,1],datas[1:n,3],type="l",col="green",lty="solid")
But I just see the first curve. I have tried it on
2009 Nov 13
4
Change working directory
Hello, I am using setwd() to change the working directory but I have to enter
it everytime I open R, is there a way to set this permanently as a working
directory? Thanx =^D
--
View this message in context: http://old.nabble.com/Change-working-directory-tp26337486p26337486.html
Sent from the R help mailing list archive at Nabble.com.
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
Hello!
I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case).
What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts):
> sqlSave(con, x, tablename =
2008 May 07
0
RODBC sqlSave with multiple schema in DB2
Hi,
I am trying to use sqlSave to write a dataframe to an existing table in a
DB2 database. The database contains two schemas. My experience is the
following: (1) in the case that tablename is left empty in sqlSave, R
writes to the instance level schema (2) in the case that a tablename is
specified and that table name exists only once in the database, R will
write to that table irrespective
2006 Mar 23
0
sqlSave
Dear Tobias,
I finally succeeded in exporting my dataframes from R into Access with
this script:
library(RODBC)
canal <- odbcConnectAccess("D:/Floristique.mdb")
sqlSave(channel=canal, dat=flore, tablename="Floristique", rownames=F,
safer=F, fast=F,
varTypes=c(dates="Date"))
odbcClose(canal)
My problem in exporting my dataframe "flore" seems to
2007 Feb 02
0
New RODBC: a problem with sqlSave
Till yesterday I was more than satisfied by RODBC, specifically by
sqlSave which I had been happily using in a daily crontab R batch job
regularly updating a postgresql db for as long as one year. In this R-
batch I was able to save records into indexed tables *** even though
*** they already existed. in this case sqlSave simply neglected those
rows of the input table that were offending the
2010 May 20
0
RODBC: sqlSave leave primary key and other columns null
I have an existing table, and I am trying to use sqlSave to append
additional rows to this database. I omit the primary key, which is a
uniqueidentifier type (MS SQL), so that the database can populate that
field. However, I get the following error:
> sqlSave( ch, result, tablename=thetablename, append=TRUE,
rownames=FALSE, colnames=FALSE )
Error in odbcUpdate(channel, query, mydata,
2006 Dec 22
1
bug in sqlSave with fast=F option (PR#9429)
Full_Name: Paul MacManus
Version: 2.3.0
OS: Windows XP
Submission from: (NULL) (216.90.169.253)
See also R-help thread for October 18, 2006
---------------------------
Create a dataframe and save it to a database table "test" as follows:
df <- data.frame(T=1, S=10)
sqlSave(channel, df, "test", rownames=F)
The table now looks like
T S
1 10
If I create another
2011 Nov 10
1
Help: sqlSave Error
I am using sqlSave to save my data into an existing table at MS SQL Server
database. Previously my code ran smoothly but all of a sudden it stopped
working. Here is my code:
sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE)
Error: sqlSave(con, highVol, "jrgchis.dbo.futuresHighVol", append = TRUE, :
42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL
2006 Oct 18
2
sqlSave, fast=F option, bug?
Hi,
Using the fast=F option, sqlSave saves without matching column names.
It looks like a bug to me..........
Here's a simple (artificial) example.
-----------------------------------------
Create a dataframe and save it to a database table "test" as follows:
df <- data.frame(T=1, S=10)
sqlSave(channel, df, "test", rownames=F)
The table now looks like
T S
1 10
If
2007 Oct 22
0
RODBC problem: sqlSave not working after an update
Good day, all.
I just upgraded to R 2.6.0. I re-installed my most-used packages including RODBC to be sure I'm up-to-date. I have been working with a large insurance claims dataset stored in a MS-Access database on a Windows machine. I have been regularly exporting tables from R into it using sqlSave. It's worked like a charm until today, when this happened:
>
2009 Jul 08
0
RODBC and sqlSave issue
Hello,
I contact you after having unsuccessfully asked my question to R mailing list.
I use the package RODBC to connect to a MS-SQL server.
I am able to getQuery from the database.
I
am now studying the sqlSave some data into the database. Unfortunetly,
I meet some issues relating to the format of the data that arrives into
the database. I have three columns. The first one should be in the
2003 Jan 29
1
RODBC sqlSave Error
Hi,
i get error after using a data.frame with subset for "sqlSave".
What can i do ?
It seems that lines like this in a data.frame structure are after subset
deleted and cause
the error ?
- attr(*, "variable.labels")= Named chr "CUSID" "Welle"
"Arbeitgeberfavorit1" "Aktuelle Bewerbungssituation" ...
..- attr(*, "names")=
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,
2003 Apr 02
1
RODBC sqlSave problem.
Dear list,
Being new to both the postgres database, ODBC and the RODBC interface, I
am somewhat confused by some of the problems I am experiencing trying to
connect R to the database.
Whai I am trying is basically the example part of the help file for the
sqlSave function:
> library(RODBC)
> odbcConnect("theodor") -> channel
> data(USArrests)
> sqlSave(channel,
2010 May 16
1
RODBC-Error-sqlSave
Dear R-community,
After repeating the sqlSave-command 3 times on a dataframe (of size 13149
rows * 5 columns) to my MS-Access database I get the following error:
*Error in sqlSave(channel, eksport_transp_acc_2, "transp_acc_scenarier", :
unable to append to table ‘transp_acc_scenarier’*
**
This means that the first 2 savings are completed, but the third-one
is somehow not. I have an
2005 Mar 15
0
Fwd: RODBC, sqlSave and sqlAppend
Début du message réexpédié :
> De: Depiereux Constant <constant.depiereux@aqte.be>
> Date: 16 mars 2005 00:11:11 GMT+01:00
> À: spjgmwn@iop.kcl.ac.uk
> Objet: Rép : [R] RODBC, sqlSave and sqlAppend
>
>
> Le 15-mars-05, à 16:19, Matthew W Nash a écrit :
>
>> Hi all,
>>
>> I am currently trying to read, write and append data between R and MS