Python with win32.com and pythoncom - convert *.MDB to mySQL

Navigating: Home > Navigator > Programming > Python

(Navigator)

Programming

15.Python | 16.robertbody C++ & *.BAT |
17.Unix Notes (live) | 18.Perl Notes (live)

Python

cygwin/

--python/
    mdb.py      # converts *.MDB Micorosft Access file to mySQL syntax, and writes the text file
                # see mySQL page to see my other tools, for importing into mySQL database

• www.python.org

PythonWin GUI + command line

• www.win32com.de
(Windows extensions
for Python)
pythoncom & win32com
in pywin32

to install
DA0 3.6 in PythonWin:
Tools :: COM Makepy utility ::
Microsoft DAO 3.6 Object Library (5.0)

(needed for jet2sqp.py)

*.MDB and databases

DAO - Data Access Objects
• jet2sqp.py - Python code reads schema of *.MDB Windows object and writes SQL syntax
• starship.python.net/crew/bwilk/access.html - reading data via DAO

ADO - Active Data Objects
• www.ecp.cc/pyado.html - Python and ActiveX Data Objects (ADO)

Unicode

downloads.egenix.com/python/Unicode-EPC2002-Talk.pdf - Python and Unicode
www.xml.com/pub/a/2005/06/15/py-xml.html - Unicode

diveintopython.org/xml_processing/unicode.html - Python Unicode

English   0-127                         ASCII (7-bit)
French    0-127 + 128-255               ISO-8859-1 (aka “latin-1”)
Spanish  
German    
Unicode   0-127 + 128-255 + 256-65535   16-bit  "UTF-8", "UTF-16"

www.pycs.net/users/0000323/stories/14.html
www.reportlab.com/i18n/python_unicode_tutorial.html
www.joelonsoftware.com/articles/Unicode.html --- Unicode history
www.amk.ca/python/2.0 - Python 2.0, Unicode
diveintopython.org/xml_processing/unicode.html - Dive Into Python - Unicode
www.jorendorff.com/articles/unicode/python.html - Unicode in Python

python.active-venture.com/ - Python Documentation Release 2.3.3 (December 19, 2003)
starship.python.net/quick-ref1_52.html - Python 1.52 Quick Reference
Python Library Reference
Date/Time in Python
Py2exe - making executables from Python code

Counter:

Last Updated: Thu, November 24, 2005 0:30