Bulk Insert from Dataframe

31 Views Asked by userr At 26 February 2024 at 04:52

Can i do Bulk Insert from dataframe instead from a csv file

here is my code

sql = " BULK INSERT " + str(tbl_name) + "  FROM '" + fl_path + "' WITH (FIRSTROW = 2,FIELDTERMINATOR='',ROWTERMINATOR = '\r\n',CODEPAGE = '65001'); "
engine.execute(text(sql).execution_options(autocommit=True))

There are 0 best solutions below