Re: [R] importing data to SQLite database with sqldf

2009-02-21 Thread Gabor Grothendieck
: Gabor Grothendieck ggrothendi...@gmail.com To: Stephen Tucker brown_...@yahoo.com Cc: R-help r-h...@stat.math.ethz.ch Sent: Friday, February 20, 2009 5:22:09 AM Subject: Re: [R] importing data to SQLite database with sqldf Have just added an example 12 on the home page: http

Re: [R] importing data to SQLite database with sqldf

2009-02-20 Thread Gabor Grothendieck
Have just added an example 12 on the home page: http://sqldf.googlecode.com that shows an example. Note use of notation main.mytable to refer to an existing table in the main database (as opposed to a data frame in R). On Thu, Feb 19, 2009 at 11:55 PM, Stephen Tucker brown_...@yahoo.com wrote:

[R] importing data to SQLite database with sqldf

2009-02-19 Thread Stephen Tucker
Hi all, I am attempting to learn SQL through sqldf... One task I am particularly interested in is merging separate (presumably large) files into a single table without loading these files into R as an intermediate step (by loading them into SQLite and merging them there). Taking a step back,