[R] [SQL]

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Thu Apr 25 19:09:37 CEST 2013

The format of files with a SQL extension are not necessarily well- defined. In most cases I have found, they are text files that contain SQL Data Definition Language statements (CREATE TABLE) and possibly Data Manipulation Language statements (INSERT INTO). You may be able to extract the portions of the files that contain data using read.csv and judicious use of the skip and nrow arguments, but you will have to first become familiar with the contents of the file using a text editor. If they are binary files, you may need to consult with the source of the data to identify the format used more precisely.
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
Sent from my phone. Please excuse my brevity.

Ignacio Martinez <ignacio82 at gmail.com> wrote:

>The data for my new project are in a bunch of .sql files, instead of
>clasic csv files that I'm used to work with.
>Could someone explain to me how to read these files into R?
>	[[alternative HTML version deleted]]
>R-help at r-project.org mailing list
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list