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
Recommended Answers
Jump to PostI'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
All 2 Replies
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.