Displaying 2 results from an estimated 2 matches for "accessdatabaseengin".
Did you mean:
accessdatabaseengine
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
...R: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
ODBC connection failed
After that as it suggested in R data import/export manual I
installed AccessDatabaseEngine.exe. Also I used ODBC in
c:\Windows\SysWOW64\odbcad32 to create data source called result. I check
if it is created:
> odbcDataSources()
dBASE Files
"Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)"...
2010 Dec 17
2
RODBC for 64-bit R with 32-bit Access
...any more about this issue, I would be grateful for the
information!
Thanks,
Allie
R 2.12.0
Windows 7 Pro x64
Access 2007
from Ripley's ODBC Connectivity
"32-bit Windows drivers for Access 2007 and Excel 2007 are bundled with
Office 2007 but can be installed separately via the installer
AccessDatabaseEngine.exe available from .... The Access/Excel 2010 versions
at ... have a 64-bit version: however the 64-bit drivers cannot be installed
alongside 32-bit versions of Office (as far as we know, and defnitely not
for Office 2007)."
odbcConnect docs:
"You must have the 32-bit drivers when using...