search for: odbcconnectaccess2007

Hi all, I am very new to R and I'm trying to import data from Microsoft Access. So far, I've managed to do so successfully using the following code: testdb <- file.path("c:\Databse.accdb") channel2 <- odbcConnectAccess2007(testdb) data.table <- sqlFetch(channel2,"data") This successfully imports a table(?) called "data.table". But when I try to run basic stats or manipulate the data I've imported, I can only do so when specifying "data.table", rather than the variables names (li...

...(tblDataFieldRawSiteVisit.dataForm)="Oyster Transition Plan Site Mapping Detail"));) I get the following error message: Error in source(.trPaths[5], echo = TRUE, max.deparse.length = 150) : C:\Users\sranney\AppData\Roaming\Tinn-R\tmp\selection.r:2:32: unexpected symbol 1: db <<- odbcConnectAccess2007(paste(dbPath, dbName, sep = '')) 2: testData = sqlQuery(db, SELECT tblDataFieldRawSiteVisit. ^ Previous RODBC/SQL statements used by other coders at my firm have a single quotation mark around the SQL query, so I try that: testData = sqlQuery(db, 'SELE...

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 <- sqlFetch(a07.connect,'Analysis File 2007-2009') #puts dfc data into table mydata str(dataset) #this works and gives correct values HGlt102009=dataset[,6] HGBL10_F_2007 =dataset[,11] HGmt122009=dataset[,...

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

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

Well im thoroughly frustrated after 25 minutes of checking and rechecking my path. What do i not know about loading a mdb that is keeping me from loading my data. i have loaded the Hmisc library and pointed it too my data using mdb.get and continue to get the following error. Error in system(paste("mdb-tables -1", file), intern = TRUE) : 'mdb-tables' not found Which i