Re: [R] Help with RODBC connection to multiple MS SQL Sever databases

2009-07-16 Thread Allan Engelhardt
On 16/07/09 00:13, Chris Anderson wrote: I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of t

[R] Help with RODBC connection to multiple MS SQL Sever databases

2009-07-15 Thread Chris Anderson
I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connecti