Top "Rodbc" questions

RODBC provides an ODBC database interface for R. The CRAN package provides access to any Open DataBase Connectivity (ODBC) accessible database.

R RODBC Show all tables

I'm trying to catalog the structure of a MSSQL 2008 R2 database using R/RODBC. I have set up a DSN, …

r odbc rodbc
Problems with RODBC sqlSave

I'm having some difficulty inserting a data frame into a mySql database using RODBC. Below is the code I'm using: …

mysql r rodbc
RODBC fails: "invalid character value for cast specification" - Excel 2007

I'm trying to use RODBC to write to an Excel2007 file and I keep getting errors. I've reduced the issue …

r rodbc
Running SQL query through RStudio via RODBC: How do I deal with Hash Tables?

I've got a very basic SQL query that I'd like to be able to view in R. The trouble is, …

sql r hashtable rodbc
Querying Oracle DB from Revolution R using RODBC

RODBC error in Revolution R 64bit on winxp64 bit connected to Oracle using a 64bit ODBC driver thru a DSN …

r rodbc
Is there a better way to code this sqlQuery in R?

I'm writing an R script to get some database data and then do stuff with it, using the RODBC package. …

sql r formatting rodbc
MS-SQL Bulk Insert with RODBC

Is it possible to perform a bulk insert into an MS-SQL Server (2000, 2005, 2008) using the RODBC package? I know that I …

sql r rodbc
odbcConnectExcel function from RODBC package for R not found on Ubuntu

Installing the RODBC package on Ubuntu is a bit of a kludge. First I learned to install the following: $ sudo …

r packages rodbc
Connect R and Vertica using RODBC

This is my first time connecting to Vertica. I have already connected to a MySQL database sucessfully by using RODBC …

r rodbc vertica
Why am I getting warnings about closing unused RODBC handles?

I use RODBC with R and knitr to do some reporting using various production databases. In some of these reports …

r rodbc