similar to: consulta por varTypes de sqlSave en RODBC

Buen dia Javier, muchas gracias por tu ayuda y el script compartido. Me va a servir como ayuda para seguir aprendiendo sobre RODBC pero no encuentro una solucion para este problema puntual de poder definir el tipo y ancho de las variables, q segun creo se hace con el argumento varTypes. Si alguien tien algun ejemplo donde haya usado la SqlSave y VarTypes, me sera de gran ayuda. Abrazo a todos

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be

Hello, I would like to call a function that can take infinite time to be executed in some circumstances (which can not be easily detected). So, I would like that once the function is being executed for more than two seconds it is stopped. I have found documentation for timers but i did not found how to "kill" a function. Moreover, I would like not to change the function code (it should

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")=

Dear all, Hope you are doing great. I am currently using R version 3.4.1 ("Single Candle") and was trying to install packages RODBC and RODBCext using the following steps: > install.packages("RODBCext") Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4? (as ?lib? is unspecified) also installing the dependency ?RODBC? trying URL '

I don't use Windows, but this looks like a Windows permissions issue, no? You could try moving them yourself manually or create another library directory that R can access to put them in. ... or wait and hope for advice from someone who uses Windows to give you a definitive answer. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and

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,

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

I am using R2.6.0 on “Windows Small Business Server 2003”. I apologize if the answer to my question is available…I have searched but have not found anything that I thought helped me. I have a dataframe that contains ~4.5 million rows and 5 columns. (see memory and df details below). I am trying to save the dataframe to a MS SQL Server database, using the “sqlSave” function. The code

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append

Hi, I am having trouble to write/create a table, which has a date field. I want to create a stock price table, which has fields of ticker, date, price. First, I created such a table in Microsoft Access with a few rows inputs. Using sqlQuery, I found that the date field was retrieved as POSIXct value. Then I made a data.frame with POSIXct as the data type for dates. However, I received the

Hola Carlos, el ubuntu tiene compilador :) Este es el error completo al querer instalar el paquete stringr Installing package into ?/home/jose210179/R/i686-pc-linux-gnu-library/3.2? (as ?lib? is unspecified) --2016-03-15 21:46:23-- https://cran.rstudio.com/src/contrib/stringr_1.0.0.tar.gz Resolviendo cran.rstudio.com (cran.rstudio.com)... 54.230.163.212 Conectando con cran.rstudio.com

Buenas, he intentado varias veces instalar knitr y Rmarkdown tanto desde Rstudio como desde la terminal de Ubuntu usando diferentes codigos y en nunca consegui q lo instalara. el error q tira es el siguiente: Warning in install.packages : installation of package ?/tmp/RtmpavyTWw/downloaded_packages/stringr_1.0.0.tar.gz? had non-zero exit status Alguien me podria ayudar, porq estoy dejando

Hola, Por favor, necesito insertar una fila debajo de las filas que tengan DV distinto de cero, pero no me deja insertar hasta el final de la tabla. Esta es mi tabla y este es el código con el que estoy apurado. C ID TIME DV AMT RATE CMT SS II EVID GRUPO VISITA DOSIS VECES FORMA NAP EDAD SEXO ALTURA PESO 11 0 0 3 0 1 1 12 1 3 0 3 2 1 0 77 2 147 74 11 1.417 0.001 0 0 2 0 0 0 3 0 3 2 1 0.001

Hola, Por favor, necesito guardar en un mismo documento tres gráficos y que éste se pueda abrir en powerpoint para poder insertar las tres gráficas allí. Con jpeg() sólo se me guarda la última gráfica. ¿Alguien me puede ayudar?. Muchas gracias

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

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

Hello, After a (bad) first try some months ago, I'm trying again to use RODBC package instead of DBI+RMySQL packages to populate MySQL database. The main command is sqlSave(channel, data_df, tablename, append=T, rownames=FALSE, colnames=FALSE, fast=FALSE, varTypes=vartypes) where data_df is the data.frame I want to save and vartypes is obtained following the tip given here

Hola, ¿qué tal? Me han pedido que genere unos gráficos para insertarlos en un docuemento de Word. Yo suelo generar gráficas en formato PNG, pero me han dicho que "quedan mal". Y yo apenas sé nada de Word. ¿Cuál sería el formato gráfico más adecuado en este caso? Un saludo y muchas gracias, Carlos J. Gil Bellosta http://www.datanalytics.com

Hey everyone, I don't have a question. Instead some helpful advice with things I've learned from trying to connect 'R' to databases using RODBC. ROBDC is a very handy tool that, once you have everything fixed up nicely, is a great way to have scripts run fairly autonomously, safe in the knowledge that data isn't accidentally messed up. But I was fairly ignorant