Displaying 1 result from an estimated 1 matches for "bev_g".
Did you mean:
beg_g
2002 Mar 19
0
RODC-Connection to more than one file
...v.XLS -> area name:
BEV
># Sheets: DatAllg.XLS -> ALLG
># DatBev.XLS -> BEV
>channel <- odbcConnect("DatAllg")
>tt1 <- sqlQuery(channel, "select b.REGCODE, a.NAME, b.JAHR, b.BEV_G from
ALLG as a, `C:/Arbeit/Database/Daten.DatBev`.BEV as b where ((a.REGCODE =
b.REGCODE) and (b.REGCODE>=5500000 and b.REGCODE<5700000)) order by
b.REGCODE, b.JAHR")
>odbcClose(channel)
>print(tt1)
If my code is too complicated please show me another example with two Excel
file...