Displaying 1 result from an estimated 1 matches for "datbev".
2002 Mar 19
0
RODC-Connection to more than one file
...one Excel-file via RODBC
with one single sqlQuery-command? The RODBC-manual shows how the sql command
shoot run, but every time I try, I got an error, that the ODBC-connection to
one of the files was not successful. If I make a sqlQuery for only one file
(e. g. in DatAllg.XLS without variables from DatBev.XLS / b. ...), the
ODBC-connection works fine.
Do I need a second channel? If so, how can I use two odbcConnect's in one
sqlQuery?
Here ist my R-source code:
>library(Rodbc)
># Specified Excel files in ODBC as User DSN: DatAllg.XLS -> area name:
ALLG
>#...