similar to: Imported tables from Access 2007

Hi all, I'm trying to import Microsoft Access data into R. It looks like I'm supposed to use the ROBC package, and this works fine with old Access files (those with an .mdb extension). However, lovely Microsoft must constantly update their software. Modern Access files have an .ACCDB extension. I cannot seem to coerce R to import data from such a file. Any advice? I've been using

Hi List, I used to access a Paradox database using RODBC, but since last week I am not able anymore to fetch any table which has a name longer than 11 or 12 characters. Here is the the pattern of my code, nothing spectacular: library(RODBC) channel2<-odbcDriverConnect('DSN=xxx') #table names with up to 11 characters still work sqlFetch(channel2, 'abcdefghijk') #table names

Dear R-community, I'm analysing some noise using the nlme-package. I'm writing in order to get my usage of lme verified. In practise, a number of samples have been processed by a machine measuring the same signal at four different channels. I want to model the noise. I have taken the noise (the signal is from position 1 to 3500, and after that there is only noise). My data looks like

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30

Hi all, I am facing a problem while using rails "migrate" feature for creating tables in a database. Following are the details. I have 2 applications say "app1" & "app2". I want both of them to use same database say "testdb". For "app1", I create 3 models which in turn create 3 migration files with prefix, 001_, 002_ & 003_. Now I

SQldf with sqlite and H2 I have a large csv file (about 2GB) and wanted to import the file into R and do some filtering and analysis. Came across sqldf ( a great idea and product) and was trying to play around to see what would be the best method of doing this. csv file is comma delimited with some columns having comma inside the quoation like this "John, Doe". I tried this first

Hi, I want to import some data from Access and I am using the following codes: testdb <- file.path("c/../db1") channel <- odbcConnect("testdb") sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE) It comes out the error message: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default

Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this take > 1G RAM? I run R on suse linux, with 1G RAM and with the code below it even fills the whole 1G of swap. I just

Dear List, I have a problem with RODBC on a Paradox-DB, sqlQuery, and special characters in table names. Unfortunately, some of the latter include the underscore <_>. And I am not able to change them. That's not a problem, when I quote the table name: > sqlQuery(channel2, 'SELECT * FROM "anmeldung-alt"') Btw, if I swap ' and " it does not work: >

Buenos dias, Tengo la siguiente duda. Desde una hoja de calculo .xls me descargo un fichero en r as.matrix. Time VAR_2 VAR_3 VAR_4........ VAR_N Fechas(n) Precios Precios Precios Precios Fechas (n-1) ¿como puedo hacer para graficar de forma ordenada (fechas) cada uno del vector columnas (son precios de activos)? [[alternative HTML

Hello, I'm wondering how I can merge two featuresets into one. My dataset is two sets of microarray data and it looks like followings: > rawData $v1 TilingFeatureSet (storageMode: lockedEnvironment) assayData: 2197815 features, 59 samples element names: channel1, channel2 protocolData rowNames: LT290677RU_D1_2011-02-16 LT286300LU_D1_2010-07-24 ... LT003990RU_D1_2010-11-04 (59

Hello, I have a dataframe (var_1, var_2, ..., var_n) and I would like to export summary statistics to Latex in the form of a table. I want specific summary statistics by crossing numerous variables 2x2 AT ONCE. In each cell I would like sometimes to have the median (Q1 - Q3), or frequency and proportion, etc. CrossTable, xtab, etc... do not allow for multiple 2 by 2 crosstabulation. The table

First of all, sorry for the crossposting, but I put this into the Ruby Forum first of all, but was pointed to this as a more appropriate location. I''m using ActiveRecord and ActiveSupport in a non-rails environment to connect to multiple databases, and I''ve found the following (single database) to cause me an error. Note that params is my database settings and omitted for

Hi guys, Having issues with doing an insert statement using ast 1.4.24: [START] dsn=mssql-asterisk write=INSERT INTO testdb (callarrival,callerid) VALUES ('${VAL1}','${VAL2}') SET(ODBC_START()${TIMESTAMP},${CALLERID(num)}) No errors pop up on execute, but nothing gets inserted. Read and update work fine, Wondering where I'm going off track with this, Thanks,

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

All - I'm new to SQL and the RODBC package. I've read the documentation associated with the RODBC package, but I'm still having problems with my SQL statements; I think my syntax, particularly with respect to my WHERE statement, is off but I can't find any documentation as to why. When I run a query from within the Access2007 database, it looks like this: SELECT

Hi all, I installed Rails 3.0 + PostgreSQL 8.4. Installed the gem postgre-pr I added " gem ''postgres-pr'' " to my Gemfile I defined my database.yml with: # PostgreSQL 8.4 development: adapter: postgresql encoding: unicode database: testdb pool: 5 username: test password: ****** I run rails server which starts, but application environment returns this error:

Hi There, I get the following error from the code pasted below: Error in storage.mode(test) <- "logical" : object 'HGBmt12_Natl_Ave_or_Facility' not found library(RODBC) library(car) setwd("c://temp//cms") a07.connect <- odbcConnectAccess2007("DFC.accdb") sqlTables(a07.connect) ##provides list of tables## dataset <-

can somebody that has these hardwares(X101P and S400P) working on his asterisk system please assist.................. you can send the solution to austino@skannet.com..... the error message is what i have below. ---------- Forwarded message ---------- Date: Thu, 1 May 2003 21:01:21 +0100 (WAT) From: austino@skannet.com To: asterisk-user@lists.digium.com Subject: Error working with X101P and

Hello, I've added a Channel Device through virt-manager GUI. virsh dumpxml shows the device as. <channel type='unix'> <source mode='bind' path='/var/lib/libvirt/qemu/channel/target/ubuntusaucy.marx'/> <target type='virtio' name='marx'/> <alias name='channel2'/> <address