Matrix calculations from database linked to in RODBC
I am back to R after a long absence and have a few questions.
I have connected to a very large Microsoft Access database through RODBC in
hopes that I would be able to do some matrix algebra on the many tables I
have loaded into the database. What I am thinking of doing is to assign
specific columns without loading the tables as a data frame as they are
very large. I am at a loss for exactly how to do this (and of course listen
if you have a better idea).