Re: [R] Imported tables from Access 2007

2010-03-18 Thread Ryan Utz
David, Thanks for responding. You were right; I misplaced a backspace (\) with a forward space (/) in my posting. The c:\ doesn't actually work; in my true code there is a forward space. Anyway, the results of str(data) appears as follows: 'data.frame': 90 obs. of 9 variables: $ Fish (PCOrd)

Re: [R] Imported tables from Access 2007

2010-03-18 Thread David Winsemius
On Mar 18, 2010, at 7:04 PM, David Winsemius wrote: (I am attaching your original question so it will be easier for me and those who choose to comment further,) 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 usi

Re: [R] Imported tables from Access 2007

2010-03-18 Thread David Winsemius
(I am attaching your original question so it will be easier for me and those who choose to comment further,) 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

Re: [R] Imported tables from Access 2007

2010-03-18 Thread David Winsemius
On Mar 18, 2010, at 5:43 PM, David Winsemius wrote: On Mar 18, 2010, at 4:46 PM, Ryan Utz wrote: 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")

Re: [R] Imported tables from Access 2007

2010-03-18 Thread David Winsemius
On Mar 18, 2010, at 4:46 PM, Ryan Utz wrote: 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") I am surprised that worked. I was under the impression

[R] Imported tables from Access 2007

2010-03-18 Thread Ryan Utz
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