AFAIK you need to use the 32bit version of R for getting the data. Then you can
save it into a more versatile format and re-read it if you really need to run R
in 64 bit mode.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
kpzimmer <kpzim...@ucalgary.ca> wrote:
>Hello,
>
>I'm new to R and am trying to access data from a Microsoft Access 2010
>database. I've read through the RODBC package vignette and seem to
>understand the instructions of the commands but can't see to connect to
>the
>database. I have installed the Access Database Engine from the
>Microsoft
>website. I get the following errors when I try to connect:
>
>> channel <- odbcConnect("K:/UWRRDatabase_9Feb2012")
>Warning messages:
>1: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") :
> [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
>Manager] Data source name not found and no default driver specified
>2: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") :
> ODBC connection failed
>
>I setting up a ODBC connection in ODBC data sources in the
>Administrative
>Tools of Control panel and also through
>C:\WINDOWS\SysWOW64\odbcad32.exe
>but I must not be setting things up correctly.
>
>Any advice or suggestions to solve this problem would be much
>appreciated.
>
>Thanks in Advance.
>
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/Get-data-from-Access-2010-database-tp4511271p4511271.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>R-help@r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
