Skip to content
/ odbc32 Public
forked from vh-d/odbc32

R package for working with 32-bit ODBC drivers from 64-bit R session

Notifications You must be signed in to change notification settings

hsonne/odbc32

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

80 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

odbc32

The goal of odbc32 package is to allow connections via 32-bit ODBC drivers on a 64-bit R session.

Installation

You can install the released version of odbc32 from GitHub with:

devtools::install_github("vh-d/odbc32")

Features

odbc32 is currently based on the functionality of RODBC package.

Example

Assuming existence of a DB.accdb file in your current working directory.

# > sessionInfo()
# R version 3.5.1 (2018-07-02)
# Platform: x86_64-w64-mingw32/x64 (64-bit)
# Running under: Windows 7 x64 (build 7601) Service Pack 1

library(odbc32)
start_server()

con1 <- odbc32::odbcConnectAccess2007("DB.accdb")
sqlTables(con1)
sqlSave(con1, data.frame(id = 1:10, value = rnorm(10), name = "table1"))
sqlTables(con1)
sqlDrop(con1, "table1")

About

R package for working with 32-bit ODBC drivers from 64-bit R session

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • R 100.0%