Python: Load Data to SQL

sqlInsert = " bulk insert " + "[" + dbname + "].[" + schema + "].[" + sqltablename + "] from " + "'" + workingDir + NassNames + '.txt' "'" + """ WITH(FIELDTERMINATOR='|',ROWTERMINATOR='\r\n')"""
# print sqlInsert
cursor.execute(sqlInsert)
cursor.commit()

bulk insert [.].[.].[.] from 'C:\Users\.\economics.txt' WITH(FIELDTERMINATOR='|' ,lastrow=1)