rodbc
RODBC returning 0 values
I am accessing a commercial DB. Via prompt: select PersonCode, PersonDate from CODB.mastertable where PersonCode=42[详细]
2023-03-05 10:15 分类:问答Improving RODBC-Postgres Write Performance
I\'ve recently begun using RODBC to connect to PostgreSQL as I couldn\'t get RPostgreSQL to compile and run in Windows x64.I\'ve found that read performance is similar between the two packages, but wr[详细]
2023-02-27 01:23 分类:问答SQL Server RODBC Connection
Does anyone have开发者_运维问答 a connection string example for using RODBC and connecting to MS SQL Server 2005 or 2008.[详细]
2023-02-26 19:41 分类:问答RODBC and Access - Loading data
I am trying to load some data into R from an Access database. All of the instructions I can find say to use odbcConnectAccess(\"file.mdb\") but I cannot seem to load this function. Has it been replace[详细]
2023-02-20 16:56 分类:问答Loading table from database with large integers in R
I\'m trying to load data into a data frame in R from a state education Access database. The database provi开发者_StackOverflow中文版des information about schools in the state, and each school has a 12[详细]
2023-02-20 13:17 分类:问答Copy of Access mdb database being updated by live database
I\'m trying to compute statistics for data held in an Access .mdb database. In order to avoid interfering with the live database, I\'m working from a copy which I made by simply using copy-paste in Wi[详细]
2023-02-03 20:52 分类:问答RODBC string getting truncated
I am fetching data from MySql Server into R using RODBC. So in one column of the database is a character vector[详细]
2023-02-03 04:40 分类:问答RODBC Query Tuning
I am trying to pull data from our Oracle datamart into R using RODB开发者_开发百科C. I have been able to work through some of my issues, but I have one basic question.[详细]
2023-01-26 03:53 分类:问答RODBC sqlSave() stopping insert query when PK violated
I have developed an online survey that stores my data in a Microsoft SQL 2005 database. I have written a set of outlier checks on my data in R. The general workflow for these scripts is:[详细]
2023-01-24 09:26 分类:问答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:[详细]
2023-01-11 00:54 分类:问答