DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Python (http://www.daniweb.com/forums/forum114.html)
-   -   Export to dbf from ms access mdb (http://www.daniweb.com/forums/thread173064.html)

foker500 Feb 2nd, 2009 4:35 pm
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.

evstevemd Feb 2nd, 2009 5:44 pm
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

jice Feb 3rd, 2009 4:28 am
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/


All times are GMT -4. The time now is 5:08 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC