Displaying 1 result from an estimated 1 matches for "salmon_data".
2010 Mar 10
1
Importing Access 2007 data with ROBC
...th 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 this code:
testdb <- file.path("c:/Salmon_data.mdb")
channel <- odbcConnectAccess(testdb)
Data <- sqlFetch(channel,"Table1")
When I replace it with an Access 2007 file:
testdb <- file.path("c:/Salmon_data.accdb")
channel <- odbcConnectAccess(testdb)
Data <- sqlFetch(channel,"Table1")
it does...