similar to: Problem in reading Excel spreadsheets

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

Hi folks, Win 7 64 bit R 32 bit > install.packages("gregmisc") Installing package(s) into ‘C:\Users\satimiswin764\Documents/R/win-library/2.12’ (as ‘lib’ is unspecified) --- Please select a CRAN mirror for use in this session --- also installing the dependency ‘gmodels’ trying URL 'http://cran.ms.unimelb.edu.au/bin/windows/contrib/2.12/gmodels_2.15.0.zip' Content type

Greetings - After 20+ years of using SAS, for a variety of reasons, I'm using [R] for a bunch of things - while I'm getting a pretty good a handling [R] for script programming, and statistical analysis, I'm struggling with 'pulling data into [R]'. For reasons beyond my control, a number of the files I get sent to 'work with' are in Dbase format (*.dbf). For

Hi, I'm attempting to use the RODBC package on Windows Vista to import an excel spreadsheet. The spreadsheet has three worksheets the last of which is blank. Following an example in Phil Spector's book (p. 34), after creating a connection named con I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME

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

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>

I tried creating a .xlsx file using odbcConnectExcel2007 and adding a worksheet with sqlSave. This seems to work, I am even able to query the worksheet, but when I try opening the file in Excel I get the following message: "Excel cannot open the file 'test.xlx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file

Hello, I am trying to play with RODBC library and Excel Files. In my file (doubs.xls) there are 2 spreadsheets: > library(RODBC) > connection<-odbcConnect("Excel Files") > sqlTables(connection) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA 2 F:\\Th?se\\R\\Doubs NA Milieu$

I'm thoroughly stumped. I've been playing with RODBC and wanted to see if I could retrieve data from text files using this package as well (for the most part, this is an intellectual exercise, but occasionally I do get data files large enough in CSV format RODBC could be helpful) . I set up a DNS called "Text Files" and then ran the following code in R > library(RODBC)

Dear List In my short life as a beginning R-user i've encountered a following problem that i'm unable to solve myself: I have a database in MySQL containing table and field names as well as some data containing Polish accentuated characters (like ????), utf8-encoded. It works just fine with just any external query browser i can find, jdbc, odbc, native, whatever. Also mysql is happy

I have searched the archives for using insert into to update spreadsheets using RODBC and have come up short. So, first off, is it possible? I have put together a dummy xls table (c:\foo.xls)for exploring possibilities of RODBC. Ultimately, I am interested in replacing much of our previous use of vba macros with R ( I'd prefer elimination, but will take what I can get ). In order to

Hi folks, > install.packages("RthroughExcelWorkbooksInstaller") Installing package(s) into ?C:\Users\satimiswin764\Documents/R/win-library/2.12? (as ?lib? is unspecified) --- Please select a CRAN mirror for use in this session --- Error: subscript out of bounds > install.packages() Installing package(s) into ?C:\Users\satimiswin764\Documents/R/win-library/2.12? (as ?lib? is

I have the following problem in getting the "sqlSave" function from the example code in the R package RODBC to work with MySQL as ODBC server: - a new database is created, but no data is written to it - the example code works just fine when I use MS Access as ODBC server. ----------- offending code and output ------------------- > library(RODBC); > channel <-

Hi, i can convert excell to list in R with package RODBC ()but i don't understand 2 mistake 1) Don't read the last row of the table excell 2) Don' t take the hours My excell file call prueba4.xls and have the following rows: where prueba4.xls was make in excell (office xp) and have one spreadsheet call "Hoja1", you see each rows of she: D??a Hora col1 col2 col3 col4 col5

R 2.0.0 patched under win2000. MS Office Excel 2003. ODBC Drivers? This may not come as a surprise -- sqlFetch() (and perhaps other ?) appear not to handle table/worksheet names with spaces in them in Excel tables. I was not able to find documentation that specifically mentioned this, although the Help pages vaguely hinted that there might be difficulty with Excel's "peculiar

Full_Name: Michael Hecht Version: 1.7.1 OS: WinNT Submission from: (NULL) (193.158.76.205) I've got a problem with the RODBC library while trying to access to an MS-Excel file. The Excel file was originally exportet by a commercial software, so I cannot influence it. The problem is, that the names of the tables include spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I

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

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

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