Python: bulk data inserts in SQL Server

Question

I want to quickly put data into sql server database. Is it possible to access the bulk functions of SqlBulkCopy from CPython? I know that this is possible from IronPython, and I also know that I can create text files that I could load through T-SQL. But I would prefer a solution in which I can transfer data directly from CPython.

Answer 1

A flat file solution will be the easiest solution, but if you really need an alternative, you can use ctypes to manage the ODBC SQL Server bulk copy extension .