Export to dbf from ms access mdb

Expand Post »

This is probably a newbie question but I've figured out how to connect and query a microsoft access database via ado, but I can't figure out how to export the tables......need to export them to dbf????

Any help would be greatly appreciated.

Similar Threads

Help with automatic update problem and more in Viruses, Spyware and other Nasties

foker500

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2009

Permalink

Feb 2nd, 2009

Re: Export to dbf from ms access mdb

I'm not MS access fan but I can try to suggest.
Try to Load them in Python using dictionaries and then Save them using SQLite to save in any format

evstevemd

Reputation Points: 462

Solved Threads: 392

Senior Poster

Offline

3,681 posts
since Jun 2007

Permalink

Feb 3rd, 2009

Re: Export to dbf from ms access mdb

To read and write dbf files, try the dbfpy module :
http://www.fiby.at/dbfpy/

A snippet example :
http://code.activestate.com/recipes/362715/

jice

Reputation Points: 64

Solved Threads: 56

Posting Whiz in Training

Offline

225 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Python Forum Timeline: speed problem

Next Thread in Python Forum Timeline: Python 2.3.7 data type double

DaniWeb Message

Cancel Changes

User Name
Password