similar to: convert excell file to text with RODBC package

At 12:01 03/04/04 +0200, you wrote: >Content-Transfer-Encoding: 8bit >From: solares at unsl.edu.ar >Precedence: list >MIME-Version: 1.0 >Cc: >To: R-help at stat.math.ethz.ch >Date: Fri, 2 Apr 2004 12:47:48 -0300 (ART) >Message-ID: <50155.209.13.250.66.1080920868.squirrel at inter17.unsl.edu.ar> >Content-Type: text/plain;charset=iso-8859-1 >Subject: [R] convert

Hello, i would like import Data from Sybase DataBase to R-1.5.0 via RODBC. With this i get a connection without problems ! channel <- odbcConnect("ODBCName","LoginName","LoginPass") dataSybase <- sqlFetch(channel,"EPORT_XYZ") ,but when i try this i get a message error ? (Perhaps the _ is a problem, i know that's i.e. not usual to name

Hello I know how read a file in excel format into a R data frame using the RODBC library, but I don't know how write a R data frame in excel format. I don't understand the instructions from RODBC user manual. To read an excel file I use. library(RODBC); conex<-odbcConnectExcel("fis_quim.xls"); sqlTables(conex); data<-sqlFetch(conex,"hoja1"); Suppose I

Hi Michael, Here is the result of my first testing: (0) Dr. Watson Sorry, I should have given a more precise description: by default in R exists a function with the name 'table', if you use this name as in odbcPrimaryKeys(0, table) a Dr. Watson occurs, because table does not give a table name. However, it is always a good idea to prevent Dr. Watsons, even if it is triggered by a

I posted question before butnobody answered. I find it hard to belive that I''m the only one having to deal with excell fils. Here is my problem - my app must process and create ecxell files. I''m trying to figure out how to use POI4r and cannot find any clear instruction on how to get this working. I''m ruuning my app on Windows server. Any ideas? Is there any other

I have a couple Samba servers running 2.0.4a on Solaris 2.6. They generally give me no trouble, and have been stable for a long time. I'm in the process of qualifying 2.0.7, but feel no great urgency to upgrade. However, one day last week several users reported trouble getting to their files. I changed the debug level several times during the day to try to diagnose the problem. With

Hi all, Does anyone know how to export an excell spreedsheet into notepad in R format as a linear vector as opposed to columns? I.e. 2,3,4,5,6,7 etc. Thanks, Mary -- View this message in context: http://r.789695.n4.nabble.com/Pasting-excell-spreedsheet-into-notepad-for-R-tp4674568.html Sent from the R help mailing list archive at Nabble.com.

I am having a problem with RODBC's connections. It appears that my connection to the database is closed by R automatically before I am done with it. Here is my code: foo <- function(dsn) { db <- odbcConnect(dsn) odbcSetAutoCommit(db, FALSE) data <- someDatabaseOperation(db) data2 <- someLongCalculation(data) anotherDatabaseOperation(db, data2) # This often fails b/c the

Hello, it want to know if there is a library that transform a file in excell (*. xls) to text file(*.txt, *,prn, *.csv). Thanks

R-help, I'm trying to work out the density function by doing: > df(5.22245, 3, 22) [1] 0.005896862 > df(15.20675, 6, 4) [1] 0.001223825 In excell the result is : 0.0071060464 <*> FDIST(5.22245,3,22) 0.0100001406 <--> FDIST(15.20675,6,4) >From my point of view the differences in the second case are substantial. Can anyone give me a hint on this? Thanks in

es simple lo unico que tienes que hacer es instalar la libreria(xlsReadWrite) y direccionar y seguidamente especificar el numero de hoja de excel library(xlsReadWrite) dat.excel <- read.xls("d:/ruta del archivo/doc.xls", sheet=1) espero que te sirva ------------------------------------------ El día 18 de agosto de 2010 06:00, <r-help-es-request en r-project.org>

Dear R Gurus, I would very much appreciate some help with this code snippit from my RODBC package. R crashes or exhibits bizarre behaviour when repeatedly fetching large numbers of rows. Examples: > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx 3rd

Howdy, If ever somebody here might have encountered this, the rpm -qa commands just stuck for ages on my box ( honestly this is rhel 3 box). I done rebuilding already the /var/lib/rpm/__db* as per KB article but to no avail. Any additional hints what's to look for? One thing I notice w/c I think is weird is that we I losf the process of rpm -qa that's freezing, it's looking

Hi, I just found something weird for mongrel with static files. Performance endlessly decreases if mongrel serve static files from simultaneous requests : Here is the test setup: Ruby on Rails Mongrel (tested with 1.3.12.4 and 1.3.13-pre installed today) Ubuntu dapper, compiled ruby 1.8.4. http client : while true; do ab -n 1000 -c 30 http://localhost:3000/ 2>/dev/null | grep

I have a client who used to have an NT server, we replaced it with Gentoo Linux and Samba v3.0.9 and they are now having what appears to be some sort of file-sharing issue with Excel. When a user opens an Excel file on the file server it opens properly, no errors or warnings of any kind. But when they try to save the file, Excel warns them that "the file may have changed by someone

We are using Samba on a Sun Solaris system having shareable folders between users of Sun and NT workstations. Having recently upgraded a number of users from Office 97 to Office 2000, we are now experiencing a situation with Excel where two users can now modify the same file at the same time. This was not allowed with Excel 97. We have not made any changes to the Samba configuration and are

Aviad, My company is experiencing the exact same problem - where you able to get anything resolved? Thanks, Kurt Voelker

I have a file server running with Samba over Debian Sarge 3.1 R1. This File server store MDB and XLS files. Could anybody give me an optimal setup for my samba server (smb.conf). Actually, the performance is very poor. Thanks, Daniel Arjona Net Admin GENCO Distribution Systems http://www.genco.com/ 8740 Robert Fulton Dr Columbia, MD 21046 Ph: 410-872-0875 X12 Fax: 410-872-0877

i installed red hat 7.0, got teh codeweavers version of wine up and runnin, and i fire up the setup program for ms word 97, and it runs into this error: setup is unable to open the data file X:\~MSSETUP.t\~msstfof.t\Word97.stf';run setup again from were you ariginally ran it im stumped, what should i be doing here differently...thanks ............................... Daniel W. Schar

Hello, I am running Samba 2.0.7 on linux Redhat 7 kernel 2.2.22 as shown below. [root@serv aviad]# uname -a Linux serv.mobilitec.com 2.2.22-7.0.3smp #1 SMP Thu Nov 14 11:51:44 EST 2002 i686 unknown [root@serv aviad]# /usr/sbin/smbd -V Version 2.0.7 I encounter a problem with excwll files on sharing point which somtimes opens as a read only files, but I'm sure that only one person is using