convert Dbase (.dbf) files to SQLite databases

David Lyon david.lyon at preisshare.net
Wed Jul 15 06:39:21 EDT 2009


On Wed, 15 Jul 2009 11:53:28 +0200, Helmut Jarausch
<jarausch at 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...

Export to csv....

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...

David



More information about the Python-list mailing list