[R] Facing error in loading dababase table

[Uwe Ligges]

Abbas R. Ali wrote:
> 
> Hi
>  
> Facing error in loading dababase table. Folowing is my code:
>  
> library('RODBC')         
> channel = odbcConnect("dsn", "", "")
> data1 = sqlQuery(channel, "SELECT * FROM TABLE", as.is = TRUE)
> odbcClose(channel)  

The object data1 is there, you do not need to load it from a file!

Uwe Ligges


> load(data1)     # it is giving me error here that "In data(data1) : data set 'data1' not found"
> 
> Can anyone tell its solution?
>  
> Thanks
>  
> Abbas
> 
> 
> 
>       
> 	[[alternative HTML version deleted]]
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.