We've got a pretty large production python/sqlserver web application running, it uses win32com/ADO. I'd definitely agree with Kris as the answer to the initial post, bcp is the way to go for pushing lots of data into sql server.