Displaying 1 result from an estimated 1 matches for "sitex_data".
Did you mean:
site_data
2009 Apr 21
3
create objects in a loop and adding sqlQuery content to them
Hi there,
I've got a database or rather spreadsheet with several columns and rows.
For one column named sites I want to loop through all possible values
and retrieve
all data out of the database where site = x and write it into an
object named 'sitex_data'.
Somehow I'm really missing something as I'm not able to create these
sitex_data objects with
the database values, neither using list nor assign...
Here some code snipplets:
>library (RODBC)
>channel <- odbcConnectExcel2007 ("biomass_data.xlsx")
>site_data...