[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] To import csv file in C#
From:       Brad Hards <bradh () frogmouth ! net>
Date:       2013-02-10 20:04:53
Message-ID: 5117FD65.3060302 () frogmouth ! net
[Download RAW message or body]

On 09/02/13 13:49, mukesh kumar mehta wrote:
> Is there any option to import csv file into sqlite database with the
> help of System.Data.Sqlite.dll. As like shell command ".import
> file_name table_name".
SpatiaLite can do this (either as a virtual table, or an import). There
are probably other extensions that can do this too.

> As like "bulk insert" which uses in sqlserver. As like "Load Data"
> which uses in mysql.
This doesn't make as much sense in SQLite, because you'd be better off
just creating a new SQLite database and moving that around rather than
some dump format.

Brad

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]