Stack Overflow
Stack Overflow

Questions tagged [rodbc]

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

RODBC is an package providing an interface to database sources supporting an ODBC interface. This is very widely available, and allows the same R code to access different database systems. RODBC runs on /, and , and almost all database systems provide support for . The supported systems include , , , , and .

Repositories

Vignettes

Other resources

Related tags

802 questions
-1
votes
3 answers

R- How to do a loop on a list and output different dataframes

I'm attempting to create a loop in R that will use a vector of dates, run them through a loop that includes a SQL query, and then generate a separate dataframe for each output. Here is as far as I've gotten: library(RODBC) dvect <-…
William
  • 166
  • 10
-1
votes
1 answer

Pivot a table in SQL vs pivot same data frame in R

I have a large data set around 3 columns and 600000 rows. After pivoting it will convert to 1000 columns and 600 rows. Subset of input data Date Id Price 2014/12/03 Id1 100 2014/12/03 Id2 120 2014/12/03 Id3 …
Chaturvedi Dewashish
  • 1,469
  • 2
  • 15
  • 39
-1
votes
2 answers

How can i do a query with SQLsave in R?

I have a question about SqlSave , I Know that sqlsave Writes a Data Frame to a Table in an ODBC Database , but i would like to write an insert query. How can i do that with Sqlsave ,can u give me an example ? Thank you
foboss
  • 430
  • 4
  • 14
-2
votes
1 answer

No package called rodbc

I am using R Studio where I have installed RODBC successfully as it works fine when I run a .r script. However, when I use the very same code in an .Rmd file I get an error saying Error in library("rodbc") : there is no package called 'rodbc' …
Pip
  • 41
  • 1
  • 4
-2
votes
1 answer

Plotting data R

I have a simple tasks I would like to do. Using an RODBC connection I have connected R to a SQL server database. There are four tables in the database and they are tenors of Libor rates Libor_1_mos Libor_3_mos Libor_6_mos Libor_12_mos Each table…
user3195446
  • 147
  • 1
  • 13
-3
votes
1 answer

when I use a library(RODBC), a error message alert" unable to load odbcji32.dll"

library(RODBC) channel=odbcConnectExcel2007("d:/data/Salary.xlsx") #when run this, it alert as " unable to load odbcji32.dll" and stop, how to slove the problem.
Chunyuan Jiang
  • 61
  • 5
-3
votes
1 answer

How to fix locale errors in RODBC (WAS: R CMD BATCH: "$ operator is invalid for atomic vectors" but not in Rstudio)

Maybe related: Stack overflow: Windoes does not support UTF-8 I have a script which I can source from Rstudio, but when I try to source it from Rgui.exe or try to BATCH CMD run, I get the following error in my Rout file: Error in…
Andreas
  • 6,612
  • 14
  • 59
  • 69
1 2 3
…
53
54