Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
On Mon, 27 Jun 2011 18:05:41 +0200, Dominique Pellé wrote: >Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp. Thanks for the info. I'm not sure I understand what Spatialite is ("The SpatiaLite extension enables SQLite to support spatial data too

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Dominique Pellé
Gilles Ganault 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

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
On Mon, 27 Jun 2011 17:14:52 +0400, Alexey Pechnikov wrote: >1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite >http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf Thanks Alexey, worked the first time: # dpkg -i sqlite3-dbf_2010.08.16_i386.deb # sqlite3-dbf

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
On Mon, 27 Jun 2011 14:22:43 +0100, Carlos Rocha wrote: >I think you'll find what you need here >http://www.vlsoftware.net/ Thanks for the link. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Carlos Rocha
Hi I think you'll find what you need here http://www.vlsoftware.net/ > 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. > > ___ > sqlite-users mailing

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Simon Slavin
On 27 Jun 2011, at 2:12pm, Gilles Ganault wrote: >> As Simon said, the sqlite3 shell can import structured text files. > > But I need to first convert the DBF file into CSV, right? Your problem seems to be with opening the DBF file without the original app. So perhaps there's a general DBF

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Alexey Pechnikov
1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf 2. Or see the VirtualText extension from Spatialite project. This extension can be builded with SQLite http://sqlite.mobigroup.ru/dir?name=ext/virtualtext

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
On Mon, 27 Jun 2011 14:57:31 +0200, Stephan Beal wrote: >Google suggests several: Yes, but I'd like to save time by not having to evaluate them if someone's done this recently. There are only two converters listed on the site, and they seem to require FoxPro for DOS

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Stephan Beal
On Mon, Jun 27, 2011 at 2:51 PM, Gilles Ganault wrote: > Is there a way to open a DBF file and get a text dump? > Google suggests several: http://www.google.de/search?sourceid=chrome=UTF-8=export+dbf+file+to+text As Simon said, the sqlite3 shell can import structured

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
On Mon, 27 Jun 2011 13:42:33 +0100, Simon Slavin wrote: >Dump the contents as text and use the SQLite command-line shell to import it. Thanks for the tip, but I don't have the DBase application, just the file (it's actually three files: Two small ones with the column

Re: [sqlite] Best solution to import big DBF file?

2011-06-27 Thread Simon Slavin
On 27 Jun 2011, at 1:38pm, Gilles Ganault wrote: > 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? Dump the contents as text and use the SQLite command-line shell to import it.

[sqlite] Best solution to import big DBF file?

2011-06-27 Thread Gilles Ganault
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. ___ sqlite-users mailing list sqlite-users@sqlite.org