954,167 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Export to dbf from ms access mdb

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.

foker500
Newbie Poster
1 post since Feb 2009
Reputation Points: 10
Solved Threads: 0
 

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
Senior Poster
3,713 posts since Jun 2007
Reputation Points: 462
Solved Threads: 392
 

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
Posting Whiz in Training
225 posts since Oct 2007
Reputation Points: 64
Solved Threads: 57
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You