[R] How do people use Sweave / R / Databases

[Paul]

I'm currently using r scripts in sweave to grab some data via ODBC, 
process it then generate some tables.  I'd like to be able to give 
someone the files and let them reproduce what I've done.  Is there some 
way to store the data that is gathered by ODBC so that the second person 
can recreate the work without the database (apart from just writing it 
to a file or into the document)

Thanks

Paul.