Bulk Insert into SQL Server without a file

[rsouza]

Hi!

I'm trying to do something similar to this funcion in C#

SqlBulkCopy.WriteToServer(DataTable)

It does a bulk insert into SQL Server from a data table, instead of doing from a .txt or .csv file.

Is there any library that does something similar in Python?
I noticed that pandas has a function that can insert a dataframe, but AFAIK it inserts one row at time, and my data has around 1M rows and 100 columns...

Any suggestions?

Thanks!