<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>La verdad es que es una muy buena idea. <br>
<br>
Muchas gracias Eduardo por tu ayuda!!!<br>
<br>
</p>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>De:</b> Eduardo Freyre <efreyre@movistar.es><br>
<b>Enviado:</b> jueves, 31 de agosto de 2017 18:55<br>
<b>Para:</b> 'Jesús Para Fernández'; 'Carlos Ortega'; 'Francisco Rodríguez'<br>
<b>Cc:</b> r-help-es@r-project.org<br>
<b>Asunto:</b> RE: [R-es] Conectar Access con R</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Una solución, puede ser copiar y renombrar la BBDD a un nombre fácil de recordar (ej.: 00.mdb) y mantener dicho nombre de la BBDD como Nombre del origen de datos en el DSN.</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Y llevar al inicio del script de R como observación (con #) el nombre original de la BBDD y su path.</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"></span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Saludos</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">De:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Jesús Para Fernández [mailto:j.para.fernandez@hotmail.com]
<br>
<b>Enviado el:</b> jueves, 31 de agosto de 2017 15:18<br>
<b>Para:</b> Eduardo Freyre; 'Carlos Ortega'; 'Francisco Rodríguez'<br>
<b>CC:</b> r-help-es@r-project.org<br>
<b>Asunto:</b> Re: [R-es] Conectar Access con R</span></p>
</div>
</div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
</p>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Ya he visto como hacerlo:</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<pre id="rstudio_console_output" style="background: white none repeat scroll 0% 0%; word-break: break-all; outline: medium none; white-space: pre-wrap !important; word-spacing: 0px; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:blue"> </span></span><span style=""><span style="font-family:"Lucida Console"; color:blue">conexion<-odbcConnect("rx")</span></span><span style="font-family:"Lucida Console"; color:black"></span></pre>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Pero pense que podria elegir luego la bd que yo quisiera. Entiendo que de esta manera la base de datos siempre se tiene que llamar igual y estar en el mismo sitio, si no quiero andar modificando
de nuevo la conexion con Windows. ¿Verdad?</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"><br>
Gracias</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Jesús</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<div>
<div style="text-align: center; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";" align="center">
<span style="font-family:"Calibri","sans-serif"; color:black">
<hr width="98%" size="2" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">De:</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> Jesús Para Fernández <<a href="mailto:j.para.fernandez@hotmail.com" style="color: blue; text-decoration: underline;">j.para.fernandez@hotmail.com</a>><br>
<b>Enviado:</b> jueves, 31 de agosto de 2017 15:04<br>
<b>Para:</b> Eduardo Freyre; 'Carlos Ortega'; 'Francisco Rodríguez'<br>
<b>Cc:</b> <a href="mailto:r-help-es@r-project.org" style="color: blue; text-decoration: underline;">
r-help-es@r-project.org</a><br>
<b>Asunto:</b> Re: [R-es] Conectar Access con R</span><span style="font-family:"Calibri","sans-serif"; color:black">
</span></p>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
</div>
</div>
<div>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Acabo de hacer todos los pasos que me indicas (por cierto, muchisimas gracias por el gran detalle ne la respuesta), pero me sigu edando error:</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<pre id="rstudio_console_output" style="background: white none repeat scroll 0% 0%; word-break: break-all; font-size: 10pt !important; outline: medium none; white-space: pre-wrap !important; word-spacing: 0px; margin: 0cm 0cm 0.0001pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:blue">> </span></span><span style=""><span style="font-family:"Lucida Console"; color:blue">conexion<-odbcConnect("ProductionReport.mdb")</span></span></pre>
<pre style="background: white none repeat scroll 0% 0%; word-break: break-all; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:#C5060B">Warning messages:</span></span></pre>
<pre style="background: white none repeat scroll 0% 0%; word-break: break-all; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:#C5060B">1: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") :</span></span></pre>
<pre style="background: white none repeat scroll 0% 0%; word-break: break-all; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:#C5060B"> [RODBC] ERROR: state IM002, code 0, message [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado</span></span></pre>
<pre style="background: white none repeat scroll 0% 0%; word-break: break-all; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:#C5060B">2: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") :</span></span></pre>
<pre style="background: white none repeat scroll 0% 0%; word-break: break-all; margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New";"><span style=""><span style="font-family:"Lucida Console"; color:#C5060B"> ODBC connection failed</span></span><span style="font-family:"Lucida Console"; color:black"></span></pre>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"><img naturalheight="545" naturalwidth="617" id="img379629" tabindex="0" width="617" height="545" border="0" src="cid:image001.png@01D3228A.7CB9F7F0"></span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Ni idea de que peude estar pasando....</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black">Gracias!<br>
Jesús</span></p>
<p><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<div>
<div style="text-align: center; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";" align="center">
<span style="font-family:"Calibri","sans-serif"; color:black">
<hr width="98%" size="2" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">De:</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> Eduardo Freyre <<a href="mailto:efreyre@movistar.es" style="color: blue; text-decoration: underline;">efreyre@movistar.es</a>><br>
<b>Enviado:</b> jueves, 31 de agosto de 2017 13:41<br>
<b>Para:</b> 'Jesús Para Fernández'; 'Carlos Ortega'; 'Francisco Rodríguez'<br>
<b>Cc:</b> <a href="mailto:r-help-es@r-project.org" style="color: blue; text-decoration: underline;">
r-help-es@r-project.org</a><br>
<b>Asunto:</b> RE: [R-es] Conectar Access con R</span><span style="font-family:"Calibri","sans-serif"; color:black">
</span></p>
<div>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
</div>
</div>
<div>
<div>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Buenas:</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">A ver si te puede servir:</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">1.- Creo que ROBDC sólo corre en la versión de 32-bits, no en la de 64-bits.
</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Para ello:
</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<table class="MsoNormalTable" style="border-collapse:collapse" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:224.45pt; border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="299" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue" lang="EN-US">1.1 En R-Studio -> Tools -> Global Options -> General -> Change -></span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
<td style="width:224.45pt; border:solid windowtext 1.0pt; border-left:none; padding:0cm 5.4pt 0cm 5.4pt" width="299" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">1.2 Elegir version de 32-bits</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
</tr>
<tr>
<td style="width:224.45pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt" width="299" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="365" naturalwidth="610" id="Imagen_x0020_10" tabindex="0" width="610" height="365" border="0" src="cid:image002.jpg@01D3228A.7CB9F7F0"></span></p>
</td>
<td style="width:224.45pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="299" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="270" naturalwidth="304" id="Imagen_x0020_1" tabindex="0" width="304" height="270" border="0" src="cid:image003.jpg@01D3228A.7CB9F7F0"></span></p>
</td>
</tr>
</tbody>
</table>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p style="text-indent:35.4pt"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">1.3.a) Para que se produzca el cambio -> seleccionar la versión de 32-bits que elijas, -> aceptar –botón OK-, -> salir de R-Studio y volver a entrar en R-Studio.</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">1.3.b) O bien elegir la 2ª de las opciones del pantallazo (“Use your machine’s default version of R(32-bits)”)</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">1.4 Instalar la versión de ROBDC en tu versión de R de 32-bits: si no se instala directamente desde CRAN, bajar el archivo zip a un subdirectorio temporal e instalarlo desde ese
subdirectorio.</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">2.- Incluir la base de datos que quieras tratar en el repertorio DSN:</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">2.1 Para ello tienes que Ejecutar el programa
</span><b><span style="font-family:"Calibri","sans-serif"; color:blue">odbcad32.exe
</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">En W-10, lo encuentro en: C:\Windows\SysWOW64\odbcad32.exe (valorar el crear acceso directo en el escritorio)
</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><img naturalheight="381" naturalwidth="682" id="Imagen_x0020_6" tabindex="0" width="682" height="381" border="0" src="cid:image004.jpg@01D3228A.7CB9F7F0"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<table class="MsoNormalTable" style="border-collapse:collapse" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:400.25pt; border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="534" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">2.2 Al ejecutarlo, sale la siguiente plantilla: Seleccionar Access mdb y accdb y
</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">y pulsar botón “Agregar”</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
</td>
<td style="width:328.9pt; border:solid windowtext 1.0pt; border-left:none; padding:0cm 5.4pt 0cm 5.4pt" width="439" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue" lang="EN-US">2.3 Seleccionar Access Driver (*.mdb, *.accdb) -> “Finalizar”</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
</tr>
<tr>
<td style="width:400.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt" width="534" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="288" naturalwidth="406" id="Imagen_x0020_4" tabindex="0" width="406" height="288" border="0" src="cid:image005.jpg@01D3228A.7CB9F7F0"></span></p>
</td>
<td style="width:328.9pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="439" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="316" naturalwidth="424" id="Imagen_x0020_5" tabindex="0" width="424" height="316" border="0" src="cid:image006.jpg@01D3228A.7CB9F7F0"></span></p>
</td>
</tr>
<tr>
<td style="width:400.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt" width="534" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
<td style="width:328.9pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="439" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
</tr>
<tr>
<td style="width:400.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt" width="534" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">2.4 Cumplimentar los datos de la plantilla, y pulsar botón “Seleccionar”</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
<td style="width:328.9pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="439" valign="top">
<p><b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:blue">2.5 Indicar la ubicación del fichero, y pulsar botón “Aceptar”</span></b><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""></span></p>
</td>
</tr>
<tr>
<td style="width:400.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt" width="534" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="314" naturalwidth="520" id="Imagen_x0020_7" tabindex="0" width="520" height="314" border="0" src="cid:image007.png@01D3228A.7CB9F7F0"></span></p>
</td>
<td style="width:328.9pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt" width="439" valign="top">
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""><img naturalheight="250" naturalwidth="403" id="Imagen_x0020_8" tabindex="0" width="403" height="250" border="0" src="cid:image008.png@01D3228A.7CB9F7F0"></span></p>
</td>
</tr>
</tbody>
</table>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black" lang="EN-US"> </span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Y creo que desde aquí, ya podrías conectarte a través de R.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Espero que te pueda servir.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Saludos.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">-----Mensaje original-----<br>
De: R-help-es [<a href="mailto:r-help-es-bounces@r-project.org" style="color: blue; text-decoration: underline;">mailto:r-help-es-bounces@r-project.org</a>] En nombre de Jesús Para Fernández<br>
Enviado el: jueves, 31 de agosto de 2017 12:31<br>
Para: Carlos Ortega; Francisco Rodríguez<br>
CC: <a href="mailto:r-help-es@r-project.org" style="color: blue; text-decoration: underline;">
r-help-es@r-project.org</a><br>
Asunto: Re: [R-es] Conectar Access con R</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Voy a probar, a ver si consigo algo...</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">________________________________</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">De: Carlos Ortega <<a href="mailto:cof@qualityexcellence.es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">cof@qualityexcellence.es</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Enviado: jueves, 31 de agosto de 2017 12:15</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Para: Francisco Rodríguez</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Cc: Jesús Para Fernández;
<a href="mailto:r-help-es@r-project.org" style="color: blue; text-decoration: underline;">
<span style="color:windowtext; text-decoration:none">r-help-es@r-project.org</span></a></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Asunto: Re: [R-es] Conectar Access con R</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">De todas formas prueba a realizar la conexión de forma manual desde RStudio.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Las últimas versiones (o al menos la Preview) incluyen una pestaña "Connections" con la que a través de un Wizard puedes configurar conexiones, entre ellas a ODBC y una de las
opciones es "MS Access".</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Saludos,</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Carlos Ortega</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="http://www.qualityexcellence.es%3chttp:/www.qualityexcellence.es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">www.qualityexcellence.es<http://www.qualityexcellence.es</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">[http://qualityexcellence.es/images/1_blanco.jpg]<<a href="http://www.qualityexcellence.es/" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">http://www.qualityexcellence.es/</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">QualityExcellence<<a href="http://www.qualityexcellence.es/" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">http://www.qualityexcellence.es/</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="http://www.qualityexcellence.es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">www.qualityexcellence.es</span></a></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">QUALITY EXCELLENCE, consultores en calidad, procesos y mejora continua</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">El 31 de agosto de 2017, 12:11, Francisco Rodríguez <<a href="mailto:fjroar@hotmail.com%3cmailto:fjroar@hotmail.com" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">fjroar@hotmail.com<mailto:fjroar@hotmail.com</span></a>>>
escribió:</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Que yo sepa, la versión 32 bits no da problema para ello. En la 64 bits hace cosa de como un año, como que no estaba disponible.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Lo que hice en su momento fue en RStudio cambiar la versión para cada caso, es una chapuza, lo sé pero para ese problema me valió.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Un saludo y gracias</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">________________________________</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">De: R-help-es <<a href="mailto:r-help-es-bounces@r-project.org%3cmailto:r-help-es-bounces@r-project.org" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">r-help-es-bounces@r-project.org<mailto:r-help-es-bounces@r-project.org</span></a>>>
en nombre de Jesús Para Fernández <<a href="mailto:j.para.fernandez@hotmail.com%3cmailto:j.para.fernandez@hotmail.com" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">j.para.fernandez@hotmail.com<mailto:j.para.fernandez@hotmail.com</span></a>>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Enviado: jueves, 31 de agosto de 2017 10:06</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Para:
<a href="mailto:r-help-es@r-project.org%3cmailto:r-help-es@r-project.org" style="color: blue; text-decoration: underline;">
<span style="color:windowtext; text-decoration:none">r-help-es@r-project.org<mailto:r-help-es@r-project.org</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Asunto: [R-es] Conectar Access con R</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Buenas,</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Estoy usando R para conectarlo con ACCESS pero me da error:</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">> conexion<-odbcConnect("ProductionReport.mdb")</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Warning messages:</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">1: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") :</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> [RODBC] ERROR: state IM002, code 0, message [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especific</span><span style="font-size:11.0pt; font-family:"Tahoma","sans-serif"; color:black">�</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">
ning</span><span style="font-size:11.0pt; font-family:"Tahoma","sans-serif"; color:black">�</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">n controlador predeterminado</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">2: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") :</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> ODBC connection failed</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">> version</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> _</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">platform i386-w64-mingw32</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">arch i386</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">os mingw32</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">system i386, mingw32</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">status</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">major 3</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">minor 4.1</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">year 2017</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">month 06</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">day 30</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">svn rev 72865</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">language R</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">version.string R version 3.4.1 (2017-06-30)</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">nickname Single Candle</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Googleando he visto que solo funciona con la versi</span><span style="font-size:11.0pt; font-family:"Tahoma","sans-serif"; color:black">�</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">n
de R de 32 bits, version que estoy usando, pero que me sigue dando el error.</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Alguien ha experimentado/sufrido el mismo problema?</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Gracias</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Jes</span><span style="font-size:11.0pt; font-family:"Tahoma","sans-serif"; color:black">�</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">s</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> [[alternative HTML version deleted]]</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> [[alternative HTML version deleted]]</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">_______________________________________________</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">R-help-es mailing list</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="mailto:R-help-es@r-project.org%3cmailto:R-help-es@r-project.org" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">R-help-es@r-project.org<mailto:R-help-es@r-project.org</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="https://stat.ethz.ch/mailman/listinfo/r-help-es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">https://stat.ethz.ch/mailman/listinfo/r-help-es</span></a></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">--</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Saludos,</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">Carlos Ortega</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="http://www.qualityexcellence.es%3chttp:/www.qualityexcellence.es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">www.qualityexcellence.es<http://www.qualityexcellence.es</span></a>></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> [[alternative HTML version deleted]]</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">_______________________________________________</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black">R-help-es mailing list</span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="mailto:R-help-es@r-project.org" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">R-help-es@r-project.org</span></a></span></p>
<p><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black"><a href="https://stat.ethz.ch/mailman/listinfo/r-help-es" style="color: blue; text-decoration: underline;"><span style="color:windowtext; text-decoration:none">https://stat.ethz.ch/mailman/listinfo/r-help-es</span></a></span></p>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<table class="MsoNormalTable" style="border:none; border-top:solid #D3D4DE 1.0pt" cellpadding="0" border="1">
<tbody>
<tr>
<td style="width:41.25pt; border:none; padding:13.5pt .75pt .75pt .75pt" width="55">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: blue; text-decoration: underline;"><span style="text-decoration:none"><img id="_x0000_i1035" width="46" height="29" border="0" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"></span></a></p>
</td>
<td style="width:352.5pt; border:none; padding:12.75pt .75pt .75pt .75pt" width="470">
<p style="line-height: 13.5pt; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#41424E">Libre de virus.
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: blue; text-decoration: underline;">
www.avast.com</a> </span></p>
</td>
</tr>
</tbody>
</table>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>