Re: convert Dbase (.dbf) files to SQLite databases

X-Received	by 10.67.30.161 with SMTP id kf1mr17125985pad.21.1456839399961; Tue, 01 Mar 2016 05:36:39 -0800 (PST)
X-Received	by 10.50.88.3 with SMTP id bc3mr58611igb.6.1456839399926; Tue, 01 Mar 2016 05:36:39 -0800 (PST)
Path	csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.glorb.com!ok5no5514850igc.0!news-out.google.com!pn7ni6690igb.0!nntp.google.com!hb3no10385298igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.lang.python
Date	Tue, 1 Mar 2016 05:36:39 -0800 (PST)
In-Reply-To	<419cc0e0-3a78-4906-8420-c12ce2684bef@c36g2000yqn.googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=95.232.142.50; posting-account=SlBfMwoAAADg_NtR4er8VLC7KXSewQD7
NNTP-Posting-Host	95.232.142.50
References	<7c5n8kF25pc8bU1@mid.dfncis.de> <mailman.3145.1247654594.8015.python-list@python.org> <419cc0e0-3a78-4906-8420-c12ce2684bef@c36g2000yqn.googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<aea40346-e61d-4d70-8b83-08122456e1ee@googlegroups.com> (permalink)
Subject	Re: convert Dbase (.dbf) files to SQLite databases
From	starkwedder2009@gmail.com
Injection-Date	Tue, 01 Mar 2016 13:36:39 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.lang.python:103793

Show key headers only | View raw

Il giorno mercoledì 15 luglio 2009 18:30:29 UTC+2, John Machin ha scritto:
> On Jul 15, 8:39 pm, David Lyon <david.l...@preisshare.net> wrote:
> > On Wed, 15 Jul 2009 11:53:28 +0200, Helmut Jarausch
> >
> > <jarau...@igpm.rwth-aachen.de> wrote:
> > > Hi,
> >
> > > I have a lot of old Dbase files (.dbf) and I'll like to convert these
> > > to SQLite databases as automatically as possible.
> > > Does anybody know a tool/Python script to do so?
> >
> > > I know, I could use dbfpy and create the SQLite table and import all
> > > data. But is there something easier?
> >
> > yes...
> >
> > Use OpenOffice-Scalc or MS-Office-Excel to open the table...
> 
> Max 64K rows for Scalc and Excel 2003; 2007 can take 2**20 rows.
> Only old dBase (not dBase 7). Memo fields not handled. Visual FoxPro
> DBFs not supported by Excel even tho' VFP is an MS product.
> 
> 
> > Export to csv....
> 
> Yuk.
> 
> >
> > Use SQLite Manager (https://addons.mozilla.org/en-US/firefox/addon/5817)
> >
> > and use the import wizard to import your data....
> >
> > It shouldn't take too long...
> 
> ... before you get sick of the error-prone manual tasks.
> 
> I'd write a script that took a DBF file, analysed the field
> descriptions, made a CREATE TABLE statement, executed it, and then
> started doing inserts. Fairly easy to write. Scripts have the great
> benefit that you can fix them and re-run a whole lot easier than
> redoing manual steps.
> 
> If dbfpy can't handle any new-fangled stuff you may have in your
> files, drop me a line ... I have a soon-to-be released DBF module that
> should be able to read the "new" stuff up to dBase7 and VFP9,
> including memo files, conversion from whatever to Unicode if
> needed, ...
> 
> Cheers,
> John

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Re: convert Dbase (.dbf) files to SQLite databases starkwedder2009@gmail.com - 2016-03-01 05:36 -0800
  Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 08:39 -0800
  Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 08:49 -0800
  Re: convert Dbase (.dbf) files to SQLite databases Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2016-03-01 21:08 -0500
  Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 20:37 -0800

csiph-web