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 0 Newbie Poster
Stefano Mtangoo 455 Senior Poster
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 53 Posting Whiz in Training
To read and write dbf files, try the dbfpy module :
http://www.fiby.at/dbfpy/
A snippet example :
http://code.activestate.com/recipes/362715/
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.