Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #103793

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

Show all headers | 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