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
-- https://mail.python.org/mailman/listinfo/python-list