Here is how to do it in R. Download, install and start R and then paste
the following code into R.
Uncomment the first line (the line starting with a hash) if you don't
already have sqldf installed. This not only installs sqldf but also the
RSQLite driver and SQLite itself.
The code assumes that mytable.csv is the input file, DF is the table name
to create and db is the name of the SQLite database to use (or create).
Change these as needed. It will use the first line of the input file as
the column names and will automatically determine the types of columns by
examining the first few data rows of the input.
# install.packages("sqldf")
library(sqldf)
DF <- read.csv("mytable.csv")
sqldf(c("attach db as new", "create table new.DF as select * from DF"))
On Thu, Jul 30, 2015 at 1:58 PM, Sylvain Pointeau <
sylvain.pointeau at gmail.com> wrote:
> I understood from the mailing list, that CSV is not a defined format, then
> let's propose another format, well defined, the Excel one (which is in my
> experience a format to is good every time I had to exchange CSV files).
>
> Then why don't you propose an import of CSV from Excel (or similar)?
> csv(excel)
>
> is it possible? in a lot of cases, I cannot use sqlite (executable) because
> of the lack of a good CSV import. It would really great if this could be
> addressed.
>
> Best regards,
> Sylvain
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
