Gilles Ganault <gilles.gana...@free.fr> wrote: > Hello > > I have a 87MB file in DBF format that I'd like to import into SQLite. > > What is the best tool for this, free or affordable? > > Thank you.
Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp. To create a virtual table from a DBF file "foo.dbf" using UTF-8 as encoding for TEXT columns: spatialite> CREATE VIRTUAL TABLE virt_tbl USING VirtualDbf(foo.dbf, UTF-8); If you want to create a real Sqlite table (not virtual), you can copy the content of the virtual table into a real table: spatialite> CREATE TABLE tbl AS SELECT * FROM virt_tbl; The Spatialite shell also provides the following dot command for convenience: spatialite> .loaddbf foo.dbf tbl UTF-8 -- Dominique _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
