subject:"\[R\] get data frame using DBI package"

Re: [R] get data frame using DBI package

2021-07-01 Thread Jeff Newmiller

Please make the effort to post plain text email... formatted email gets stripped and what remains is often garbled. Most people use dbGetQuery... but reading the help page accessible via ?dbSendQuery should clarify how it should be used. On July 1, 2021 3:36:46 PM PDT, Kai Yang via R-help wro

[R] get data frame using DBI package

2021-07-01 Thread Kai Yang via R-help

Hi List,I use odbc to connect a MSSQL server. When I run the script of "res <- dbSendQuery(con, "SELECT * FROM BIODBX.MECCUNIQUE2")", the res is "Formal class OdbcResult". Can someone help me to modify the code to get a data frame?Thanks,Kai [[alternative HTML version deleted]]