best way to access ms sql server?

[Larry]

I've had pretty good experiences with win32com and ADO. There are a
couple of "standard" hitches you'll run into (like the first time you
try to figure out what the hell that value the money field just gave
you means) but I'd recommend it.

Try here: http://www.e-coli.net/pyado.html

Remember for speed in moving results into lists think rs.GetRows() not
rs.Fields.Item('blah').Value